Apipheny not working right? Blank white screen or error? Seeing a payment screen after you paid? Try signing out of your other google accounts, or try using an incognito/different browser. Google has had an issue with being signed in to multiple accounts since 2017.

Need Help?

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 still not answered, send us a message by clicking the chat icon in the lower corner of this page.

You can also email us directly at support@apipheny(dot)io, but we prefer if you send a message using the chat box. Please do NOT send both a chat AND an email, just one. We check our chat inbox more often than we check our email inbox.

We answer 100% of our messages within 1 business day, as long as you leave your email address. If you don’t leave your email in the chat box, you won’t get our reply.

In your message, include as much details and a link to the API’s documentation when possible. Screenshots help too. If you want to send us a screen recording of an issue happening, we suggest using loom.com.

We respond to all messages and emails within 1 business day.

Thanks for using Apipheny!

-Team Apipheny

Upgrade

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

Manage Subscription

If you have already upgraded to a paid plan, click here to login and manage your account:

  • change your subscription
  • cancel your subscription
  • update your payment method
  • view your invoice history
  • etc.

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

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.

When you install Apipheny, you’ll get a free 30 day trial.

Once the 30 days expire, we ask you to subscribe to an annual, monthly, or lifetime subscription plan.

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 the add-on using a secure Stripe checkout.
  • Refunds are available up to 30 days from the payment date, for any reason.

When you become a paid user, you have unlimited access to use the add-on. You can make unlimited API requests (within Google’s limits) and you can use the add-on in as many sheets as you want.

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 trust and patience with the Apipheny team.
 

Last updated: April 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 necessary improvements to Apipheny
  • The feature we’re currently working on is the ability to reference a range of values within an API request. Currently, users can only reference one value at a time.
  • Other commonly requested features that we plan to implement include authentication options and data filtering
  • We anticipate releasing the features mentioned above as soon as possible if all goes as expected but we may run into delays, as is normal in software development
  • These are just some of the new features we are working on that are closest to being completed. Our priorities are subject to change depending on different factors. If you have a feature request, contact us to let us know.

CHANGELOG

  • April 2023: Pagination features have been released. Click here to view the updates.
  • Nov 2022 – March 2023: 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:

Apipheny Videos