Apipheny not working? Blank white screen? 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.
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.
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 answer 100% of our messages, 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.
Our support hours are 9am-5pm Pacific Time (PST), Monday through Friday, excluding American holidays. We try to answer everyone within 24 hours during normal business hours.
Cheers!
-Team Apipheny
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.
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.
If price is of concern to you, please email us so we can provide you with alternate options.
If you want to cancel your subscription, you can either:
Optional: in your message to us, specify whether you want to cancel your subscription immediately or at the end of the current billing period. If possible, please also list your reason for cancelling your subscription so we can improve our product.
In the future, we will have an account management tab in the add-on, where you can view and modify your subscription, but this feature is not ready yet. We will make an announcement when it is ready.
Roadmap
February 2022
January 2022
Your lifetime subscription is not automatically activated when you purchase it on Appsumo, you have to click Redeem and follow the steps to activate it.
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.
For any error you don’t understand, just message us for assistance and in the message include a screenshot of the error message.
To fix the issue, sign out of your other Google accounts and try again, or use an incognito browser, or use a different browser.
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.
Your saved API information gets deleted when you uninstall the add-on.
Below, under “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 learn more about our scheduling feature here.
We don’t 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 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.
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.
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:
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.
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.
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/
4. Use Apipheny to GET the JSON (use the direct link from step 3 as the URI path)
We at Apipheny do not have access to any of your data, only Google does, so you have to check if 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.
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.
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.