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 ChatGPT, Bard, 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:
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 an issue with Apipheny, try taking these steps to troubleshoot the issue:
If you have an error from an API you’re trying to connect to, try taking these steps to troubleshoot the issue:
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:
You won’t be automatically charged anything when your trial ends. When your trial ends, you will be converted to the free plan.
If you’re ready to upgrade, click here to choose a paid plan.
Click here to login and manage your account:
If you want to cancel your subscription, you can either:
Latest Updates
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
CHANGELOG
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.
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.
If you’re experiencing issues with the scheduling feature:
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:
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:
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.
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/).
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.
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.
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.
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
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.