Below are a few common errors you may encounter when using AdStage's Google Sheet add-on.

Deciphering Error Messages:

#error {:message “Access not granted or expired"}

  1. Log out and log back into the add-on.
  2. If that doesn't work, update the formula by making a change to a parameter to kick off a fresh call. For example, change sort by clicks to sort by spend. After you make the change, feel free to swap it back once the data pulls through.
  3. If those two options don't do the trick, check to see if you are the owner of the sheet. The owner of the sheet needs to access and log into the add-on. If the owner of the sheet doesn't have an AdStage account, consider helping them login to the add-on with your credentials. Alternatively, you can duplicate the sheet, which switches ownership to yourself, then your formulas should pull through.

#ref {:message "Array result was not expanded because it would overwrite data in A3"}

  1. Check the cells where the formula would expand, are there formulas/numbers/letters in the way? The formula won't be able to build out if the cells required are already occupied. The error message will let you know where one of the occupied cells is. In the above example, A3 had a digit in it. 

Internal error executing the custom function.

  1.  A custom function call must return within 30 seconds. If it does not, the cell will display an error: Internal error executing the custom function. This is a limitation on Google's end. Read more here. To fix the issue, lower your limit or use a smaller date range.

Request failed for https://platform.adstage.io/api/organizations/31061/build_report returned code 500. [...]

  1. Refresh the formula. 500 errors sometimes go away on refresh.
  2. The request is too large. Try adjusting the parameters to make the call return less data. A few ideas:
  •  Lower the limit parameter. After a limit of 1000 you are more likely to hit 500 errors.  {"limit", 100}. 
  • Use targets to only include data from certain ad accounts instead of all ad accounts connected to your AdStage account. {"targets", "/network/facebook/account/29234932,/network/linkedin/account/597452157"}. More on targets here.

#name {:message "Unknown function: accounts/campaigns/ad groups/ads/keywords"}

There are a few methods to help clear this error.

  1. Log out and log back into the add-on.
  2. If that doesn't do the trick, go to Add-ons in the top menu bar and click Manage Add-ons.
  3. Click the three dots and remove the check from 'Use in this document'. 
  4. Wait a minute or two and toggle it back on.

5. If that doesn't do the trick, go to Tools and select Script Editor in your Google Sheet.

6. In the toolbar there will be a dropdown with a function in it. Select any function (myfunction is fine).

7. Click play.

8. You might have to approve permissions.

9. Close out new script tab, refresh your original sheet, potentially reload the formula.

10. If you are still hitting the error, repeat steps 2-6.

Formula parse error.

  1. This means the add-on or Google Sheets doesn't like something in the formatting of your sheet. 
  2. Make sure your parenthesis and brackets are closed. The last character in your formula should be )
  3. Confirm when referencing cells you aren't putting the cell numbers in quotes. Correct: {"targets", A3} Incorrect: {"targets", "A3"}
  4. Confirm when using numbers in your formula you aren't putting the numbers in quotes. Correct: {"limit", 100} Incorrect: {"limit", "100"}
  5. Does your country use decimal comma instead of decimal point? Your Google Sheet settings may be set to a different standard such as European Standard which treats commas as decimal points. Either update your settings or switch all commas to semicolons in your formula. Looks like this: =campaigns(“last week”; {“budget”; “spend”}) Countries that regularly use decimal comma are Europe (besides the UK), Venezuela, Chile, Argentina, Colombia, Uruguay, many countries in Africa.
  6. Is your formula showing up without Google Sheets' formula color coordination? If your formula is only showing up in a black font color, your formatting may be off. Make sure if you copied and pasted your formula from another tool (like Slack), that you retype the quotation marks fresh. Example:

Need more help? Reach out to us at support@adstage.io. 

Did this answer your question?