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 me know about an issue so we can investigate further, email me at support@apipheny.io or chat with me live by clicking on the chat icon in the bottom right corner of this page.

-Meelad Mashaw
Co-founder
Apipheny

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.

Every saved API request can be used in a custom function as so:

• =APIPHENY(“req-ID#”)

To use the function, you must reference the Saved Request ID #.

To get your request ID #, save your new API request in the “Import” tab (if it’s not saved already).

Then open the saved API request in the “Manage” tab and scroll to bottom to find the request ID #.

Example uses:

• =APIPHENY(“req-ID#”,””,A11)
  • auto-updates whenever A11 is changed
• =APIPHENY(“req-ID#”,”URL_OVERRIDE_HERE”)
  • insert an API URL in place of URL_OVERRIDE_HERE

Create an API request based on the value of a cell.

You can reference cells on the spreadsheet in any of the add-on’s form fields by wrapping them within 3 curly braces.

Examples:

This error means that the Sheet Name in the API Request does not match the Sheet Name in your Google Sheets.

Soon we’re changing this error message to say: “Error: The target sheet no longer exists. Please update the Sheet Name for this request.”

Make sure the Sheet Name in your API Request is spelled exactly the same as the name of the sheet that you’re trying to import data into.

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 or monthly subscription plan.

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, send an email from the email address you signed up with to support@apipheny.io with “Cancel my Apipheny subscription” in the subject and body of the email.

If you run into any limitations, it could be because Google Sheets has limits, and Google also has limits when using APIs.

Click here for more information.

Question: If i make an API call from a platform, would the pulled data be a direct extract of the database (i.e. 1 row per entry) or can the data be aggregated by a given dimension (geo data, time, channel, etc.)?

Answer: The data will be pulled in one row at a time and you will have to pull in the proper dimension if you want to aggregate the data.

For example, if you are pulling from Google Analytics, you want to make sure to pull in the “day”, “week”, or “month” dimension so the API consolidates that data into one row.

Click here to learn more about making a POST request in Google Sheets using Apipheny.

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

Soon we are releasing a scheduling feature that will allow you to refresh the API data in your Google Sheet every hour, day, week, or month.

We can’t add faster refreshing because Google limits add-ons (apps) to update only once per hour at most, but there is a workaround.

If you want to refresh the data in your spreadsheet faster than every hour, contact me so I can explain the workaround.