Apipheny Support

If you have an issue, or if the add-on is not working correctly, it could be because you’re signed in to multiple Google Accounts. Try signing out of your other Google accounts and see if that fixes it. This is a common issue with Google add-ons that Google is aware of but has not fixed yet.

Other ways to fix issues:

1. Try closing the add-on (clicking the x button) and opening it again.
2. Try refreshing the webpage.

If you’d like to let us know about an issue so we can investigate further, email us at support@apipheny.io or chat with us live by clicking on the chat icon in the bottom right corner of this page.

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.

Your saved API information gets deleted when you uninstall the add-on.

Privacy Policy

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

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 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 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.

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.

You will not be automatically charged when the trial ends. You have to manually enter your credit card information.

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, just contact us and let us know you would cancel your subscription, and the email address of your account.

In the same email, specify whether you want to cancel your subscription immediately or at the end of the current billing period.

Optional: 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.

If you run into any limitations, it could be because Google Sheets has limits (eg. 5 million cells), and Google also has limits when using APIs and other services such as scripts.

Contact us if you get any error messages you can’t resolve and click here for more info on Google service quotas.

If your API call requires a date and timestamp, try the following:

In Sheet 1 cell A1 in your Google Sheet, add one of these formulas:

• =(now()-5.5/24-DATE(1970,1,1))*86400000

• =TEXT(now(),”yyyy-MM-dd hh:mm:ss”)

You can try the second formula if the first one does not work.

Then, in your API request, use our reference cell value feature to replace the timestamp parameter with the following variable:

• {{{Sheet1!A1}}}

—

Example:

https://api.example.com/v1/getInfo/timestamp

Would become:

https://api.example.com/v1/getInfo/{{{Sheet1!A1}}}

So the API request would use the value in Sheet 1 cell A1 (the timestamp formula) when calling the API. Click here for more info about referencing cells in Google Sheets.

If you’re using Brave Browser, and Apipheny is not working correctly, try turning Brave “Shields” off to help resolve the issue.

• https://support.brave.com/hc/en-us/articles/360022973471-What-is-Shields-
• https://support.brave.com/hc/en-us/articles/360022806212-How-do-I-use-Shields-while-browsing-
• https://support.brave.com/hc/en-us/articles/360023646212-How-do-I-configure-global-and-site-specific-Shields-settings-
• https://support.brave.com/hc/en-us/categories/360001053072-Shields

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/

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

Is Apipheny software GDPR compliant?

We at Apipheny do not have access to any of your data, only Google does, and Google is somewhat GDPR compliant.

Apipheny software is hosted on Google servers, and all of your data passes through and is stored on Google Servers, and none of your data is sent bak to us at Apipheny. we don’t have access to any of your data.

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