Need Help?

For the optimal experience, we recommend having only one Google account signed when using Apipheny. If Apipheny is not working as expected, try signing out of your other Google accounts, or try using an incognito/different browser. Google add-ons have had an issue with users being signed in to multiple accounts since 2017, and Google developers are actively working on fixing it. This issue does not affect everyone.

1.) First, read through the FAQ and links to resources below. If you’re getting an error from the API, try googling the error to see if the answer already exists online.

2.) If your question is not related to Apipheny, but rather related to Google Sheets or an API, try using ChatGPTBard, or another AI tool to answer your question.

3.) If your question is still not answered, send us a message by clicking the chat icon in the lower corner of this page.

In your message, include the following details when possible, to speed up the troubleshooting process:

  • a link to the documentation for the API endpoint you’re trying to call
  • a screenshot of what you have entered into Apipheny, minus any sensitive info
  • a screenshot of the results you got in your Google Sheets
  • a screenshot of any errors received
  • an explanation of what you’re expecting to happen vs what actually happened
  • optional: record your screen using loom.com and send us the link to the video

We respond to messages and emails within 1 business day.

Thanks for using Apipheny and have a great day.

Upgrade or Manage Subscription

If you would like to purchase a paid plan, please click here to view options.

If you have already upgraded to a paid plan, click here to login to the billing portal and manage your subscription.

FAQ

Apipheny Error

If you have an issue with Apipheny, try taking these steps to troubleshoot the issue:

  1. Try closing the add-on (clicking the x button) and opening it again
  2. Try refreshing the webpage
  3. Try using an incognito browser
  4. Try using a different browser – sometimes a browser extension like an adblocker can cause issues. Privacy browsers like Brave can also cause issues
  5. Sign out of other accounts – sometimes google services can have an issue if you’re signed in to multiple google accounts. Try signing out of your other google accounts, or sign in to 1 google account in a different browser
  6. Open a brand new Google Sheet and see if Apipheny works in the new sheet. If it does work in the new sheet, refresh your old sheet and try opening Apipheny again in the old sheet, after enabling it in the new sheet.

API Error

If you have an error from an API you’re trying to connect to, try taking these steps to troubleshoot the issue:

  1. Check the API documentation to make sure you’ve entered your API request correctly
  2. If you’re following our tutorial, make sure you’ve followed each step exactly and contact us if you notice anything out of date in our tutorial
  3. Try making the same request using the Postman API Connector, to determine if the issue is related to Apipheny or not
  4. Make sure you’ve entered your API key, or make sure you’ve authenticated your API request correctly
  5. Error messages from the API will be displayed by Apipheny in red

If you’d like to let us know about an issue so we can investigate further, send us a message by clicking on the chat icon in the bottom right corner of this page.

Click here to install Apipheny and start your free 14-day trial. Try all of our features for free for 14 days. No credit card required.

After your trial, you can:

  • Choose to continue on the free plan, which includes limited features.
  • Upgrade to a paid plan for access to all features.

You won’t be automatically charged anything when your trial ends. When your trial ends, you will be converted to the free plan.

Upgrade

If you’re ready to upgrade, click here to choose a paid plan.

  • You will not be automatically charged when the trial ends. You have to manually enter your credit card information.
  • If you don’t want to use Apipheny anymore, you can uninstall it and unsubscribe from our emails.
  • Payments are submitted in a secure Stripe checkout portal.
  • Refunds for any payment you make are available up to 7 days from the payment date, for any reason.
Manage your subscription

Click here to login and manage your account:

  • change your subscription
  • cancel your subscription
  • update your payment method
  • view your invoice history
Cancel your subscription

If you want to cancel your subscription, you can either:

  1. Click here to login and cancel your subscription
  2. OR reply to the automated invoice email we send you every month and let us know you would like to cancel your subscription
  3. OR message us in the chat window down below and let us know you would cancel your subscription (alternatively, you can email us at support@apipheny.io)

Latest Updates

These are just some of the most pertinent updates we have made recently or that we plan to make. We are continuously squashing bugs and making improvements that are not always immediately visible or announced. Thank you for your continued support.
 

Last updated: OCTOBER 2023

PLEASE NOTE THE INFORMATION ON THIS PAGE IS NOT ALWAYS UP TO DATE. PLEASE MESSAGE US IF YOU HAVE ANY QUESTIONS. THANK YOU.

ROADMAP

  • Apipheny development is working full-time on adding highly-requested features and making necessary improvements to Apipheny
  • We are currently working on adding support for OAuth2.0 APIs (custom OAuth connections).
  • Our priorities are dynamic depending on demand and other factors
  • If you have a feature request, please contact us to let us know

CHANGELOG

  • October 6 2023: We made changes to our pricing structure.
  • August 2023: Reference a range of cells features has been released. View the documentation. View the email.
  • July 2023: Response Viewer has been released. View the documentation. View the email.
  • April 2023: Pagination feature has been released. Click here to view the updates.
  • Feb 2022: bug fixes and performance improvements; continuing work on roadmap features
  • Nov 2022: bug fixes and performance improvements; continuing work on roadmap features
  • Oct 2022: we released a new major version. Click here to view the updates.
  • June 2022: bug fixes and performance improvements; continuing work on roadmap features
  • April 2022: we released a new major version. Click here to view the updates.
  • March 2022: bug fixes and performance improvements; continuing work on roadmap features
  • Feb 2022: bug fixes and performance improvements; continuing work on roadmap features
  • Jan 2022: bug fixes and performance improvements; continuing work on roadmap features
  • March 2020 – Jan 2022: changelog was not kept/recorded at this time
  • March 2020: Apipheny was launched
Error/issue opening Apipheny

If you open Apipheny and it is a blank white screen or you see an error message, it’s probably because you’re signed in to multiple Google accounts.

To fix the issue, sign out of your other Google accounts and try again, or use an incognito browser, or use a different browser.

Google has had an issue with being signed in to multiple accounts since 2017.

Brave Browser

If you’re using Brave Browser, and Apipheny is not working correctly, try turning off your adblockers, or if you’re using Brave, turn off “Shields” to help troubleshoot the issue. More info:

Adblockers & Extensions

If you’re using extensions such as an adblocker, it may cause Apipheny not to work correctly.

API Request Errors

If you run an API request and an error comes back within the spreadsheet (in the cells of your sheet), this is most likely an error coming back from the API itself

For example you might get an error message saying that the load/volume of people trying to access the API is too high and to wait before trying to make another request.

Or you might get an error saying your access is denied either because you did not enter your API key correctly into apipheny or you don’t have an API key, etc.

Sometimes you might get an error saying you are in a banned location. Apipheny does not use unique or controllable IP addresses. Apipheny uses the Google Services IP addresses.

For any error you don’t understand, just message us for assistance and in the message include a screenshot of the error message.

Requests not running

If you’re experiencing issues with the scheduling feature:

  • Try quitting/closing Apipheny and opening Apipheny again
  • Try deleting the scheduled request and then creating it again
  • Try running the request manually from the Manage tab
  • Try signing out of your google account and signing back in

If you run many requests or a request that returns many pages of data, you may run into Google’s service limits, as described here: https://developers.google.com/apps-script/guides/services/quotas

Currently, free Google accounts get 20,000 URL Fetch calls per day, and paid Google Workspace accounts get 100,000 per day.

Google tracks each request as a URL Fetch. For example if you run a request that returns 10 pages, Google will count 10 URL Fetch calls towards your daily quota.

If you think you’ve hit your quota limits, try splitting your requests up into smaller requests spread over a longer period of time.

Click here for more info about our scheduling feature.

Google Sheets has limits and Google also has limits when using APIs and other services such as formulas and scripts.

Google API usage limits:

  • 20,000 API calls per day
  • 6 mins processing time per hour
  • 90 mins processing time per day
  • 50 mb per call

Click here for info on Google service quotas.

A google user’s quota can be limited based on the combined amount of activity from things such as scripts, addons, and formulas (eg. GOOGLEFINANCE).

These quotas, when maxed out, can interfere with Apipheny and cause scheduled requests to fail.

Google Sheets limits:

  • Up to 10 million cells per spreadsheet
  • 40,000 new rows max
  • 18,278 columns max
  • 200 tabs max per spreadsheet
  • 1,000 GoogleFinance formulas max per sheet
  • 50 cross-workbook reference formulas max (eg. ImportRange formulas)
  • 50 functions for external data max (eg. ImportData, ImportHtml, ImportFeed, ImportXml)
  • 50,000 characters maximum string length

Every API is different, so there’s not a single way to connect every API using our software.

Below, under “API Tutorials”, you’ll see guides we’ve created for connecting various APIs to Google Sheets using Apipheny, and we’re creating more guides all the time.

If you need help connecting a specific API to Google Sheets, just send us a link to your software’s API documentation so we can take a look.

Then we’ll follow up with specific instructions on connecting your API to Google Sheets.

You can use Apipheny to automatically refresh the API data in your Google Sheet every hour, day, week, or month.

You can learn more about our scheduling feature here.

We don’t currently have faster refreshing than every hour because Google limits add-ons to update only once per hour at most, as you can see here: https://developers.google.com/apps-script/guides/triggers/installable#time-driven_triggers

“Note that an add-on can use a time-driven trigger once per hour at most.” -Google

No add-on that relies on Google Services is allowed to refresh faster than once per hour, according to Google.

If Google changes this policy in the future, then we will be happy to add faster refreshing than every hour. But it is currently not possible.

We may implement a workaround in the future that would allow for faster refreshing, and we will let everyone know via email if we do add such a feature.

If you would like to try a workaround, you can write a macro or script that force updates the =APIPHENY formula as often as you’d like. For example, by deleting the formula and pasting it again.

Date

If you need the current date as a parameter in your API request, you can call the TODAY formula in a cell of your google sheets (https://www.google.com/search?q=current+date+formula+google+sheets) and then reference that cell in your API URL (https://apipheny.io/reference-cell-value-api-request/).

Time

If your API call requires a timestamp, add one of these formulas in a cell of your Google Sheet:

=(now()-5.5/24-DATE(1970,1,1))*86400000
=TEXT(now(),”yyyy-MM-dd hh:mm:ss”)

Try the second formula if the first one does not work.

Then reference the cell’s value in your API URL.

Cell Reference Example

You can replace values in your API URL, Headers, or POST Body with a variable. For example, this URL:

https://api.example.com?time=timestamp

would become:

https://api.example.com?time={{{Sheet1!A1}}}

So the API request would use the value in Sheet 1 cell A1 (where the timestamp formula is pasted) when calling the API.

Click here for more info about referencing cells in Google Sheets.

Every app that Google approves must go through a strict security & privacy approval process, including ours.

When you first install the add-on, you’ll be asked to allow access to three basic permissions that are required for the add-on to work properly.

Our code can only access your data while you’re accessing the add-on. We don’t sync your data to our own servers and we don’t have any direct access to your data.

We use Google’s PropertyService which allows us to attach limited data (such as saved API requests) to the spreadsheet itself and to the user, on Google’s servers.

We then use Google Apps Script which runs exclusively on Google servers.

We do not have access to view any of the information stored in your Sheets or any of your saved API information.

Privacy Policy

Is Apipheny software GDPR or HIPAA compliant?

We at Apipheny do not have access to any of your data, only Google does, so you have to check whether Google is GDPR/HIPAA compliant.

Apipheny software is hosted on Google servers, and all of your data passes through and is stored on Google Servers. There is no code in Apipheny that sends your data to a server we can access, so we don’t have access to any of your data.

We recommend looking into Google GDPR or HIPAA compliancy for your country to confirm.

Can I purchase 1 subscription and use it for 2 or more Google accounts?

Apipheny licenses are assigned to unique gmail accounts.

Accounts without a subscription that have access to a spreadsheet owned by the subscribed user will be able to see the results of data requests that the subscribed user makes.

If both accounts want to be able to open and modify settings in the add-on, then each account should have it’s own paid subscription.

If you want to use Apipheny with a different email address, send an email to support@apipheny.io from your current email address requesting to change to your new email address and we will process the change shortly.

Info we need:
  • email address of your current Apipheny account (with a current active subscription)
  • email address that you would like your subscription switched to

Yes, Apipheny works offline.

Apipheny and Google Sheets both work in the cloud so you can close your browser and turn off your computer and your scheduled requests will still run when you are not present.

You will see any new data that was imported the next time you open your spreadsheet.

If you have a local JSON file on your computer, here’s how you can “upload” that JSON file into Google Sheets using Apipheny:

1. Upload the JSON file to Google Drive

2. Obtain the sharing link & share for “anyone with the link”

3. Use this website to generate a direct download link (API key not required for small files): https://www.wonderplugin.com/online-tools/google-drive-direct-link-generator/ (please note this is a third party website that is not affiliated with Apipheny. Use at your own risk.)

4. Use Apipheny to GET the JSON (use the direct link from step 3 as the URI path)

It is on our roadmap to add a feature within Apipheny that will make it easier to upload JSON files from your computer or Google Drive into your Google Sheet using Apipheny. We will send out an email to everyone once that feature is ready.

Are there empty/blank rows in your sheet after you import API data?

When you scroll to the right side of the sheet, is there values in the “blank” rows that are causing those rows to appear?

Sometimes there might not be values in the visible columns, but if you scroll to the right side of the sheet you may see those “blank” rows actually have values in them.

APIs come in a lot of different formats/structures and Apipheny parses some APIs better than other APIs.

In the future the goal is that every API parses perfectly and we want to implement features that help users customize and filter their API data imports, but these features are not ready yet.

In the mean time, the API endpoint might have some parameters that allow you to filter the results, or you can write a function/formula to help deal with empty rows.

Some people treat the sheet that the data is imported into as the “raw data” sheet and they use formulas to transfer only the data that they want into a different tab/sheet.

You can change the Target sheet after you save the API request.

First, enter your API request details in the Import tab.

Then click the Save button at the bottom of the Import tab

You will then be brought to the Manage tab where you will see your saved API request.

In the Manage tab, click on the API request you saved to edit/modify it.

In the edit screen, you will see the option to change the Sheet Name, which is the target/output sheet.

More info:

How can I refresh my API access token automatically?

Currently Apipheny does not have features to support automatic refresh of the access token, but this is one of the priorities in our roadmap to implement as soon as possible.

In the mean time, we suggest using workarounds, for example, by automating the process through a macro.

Here is an example workaround:

You can write a script, using google apps script, to run your API token request on a triggered timer. This will refresh the access token and plug it in to one of the cells in your spreadsheet. Then reference that value in your API request/in the header for the bearer auth.

Apipheny uses the same pool of IP addresses for Google Sheets that everyone else uses, and currently there is not a way to change or control that.

Google controls the IP addresses for services that run on Google, like the Google Sheets API, which Apipheny relies on.

You can obtain the Google IP address ranges here: https://support.google.com/a/answer/10026322?hl=en 

If you encounter this error, please note that it originates from Google Services, not Apipheny. Google allocates a specific storage quota to each account, and the characters used to save requests contribute to this allocation. The storage limit is set at 500 kilobytes. For more info, you can refer to the following resource: https://developers.google.com/apps-script/guides/services/quotas
 
 

API Tutorials

Here we show you how to connect some of the most commonly requested APIs to Google Sheets. Every API is different so there’s not one tutorial that covers every API. If you want to know how to connect an API that we haven’t covered yet, just send us a link to your API’s documentation and we’ll see if we can create a custom guide for you.