Support for SyncWith for Google Sheets

Facebook outage: Blank page when trying to connect to Facebook

Learn about a recent outage preventing users from connecting to Facebook.

Teams

Collaborate with your colleagues on reports and data sources

Refresh a report using a sheets function

Moving reports to another SyncWith account

Learn how to copy SyncWith reports from one Google account to another

Troubleshooting Google Ads

Learn how to fix common problems that occur when working with Google Ads.

Managing the timezone in SyncWith’s Google Sheets addon

Learn how Timezone differences can often be a source of small discrepancies, and how to view and change the timezone that SyncWith uses.

How to get a Notion API key

Learn how to get an integration API key to access your Notion database.

Connecting to Postgres or MySQL

Learn how to resolve ENOTFOUND and ETIMEDOUT errors when connecting SyncWith to your SQL database.

Many Reports on a Single Google Sheet

Tutorial on how to ensure multiple reports load data onto a single Google Sheet vs multiple sheets.

Scheduled report refreshes

How to setup your reports automatically scheduled to refreshes into Google Sheets with SyncWith, hourly, daily or every five minutes

How to combine new data with your existing sheet: replace, append or synchronize

SyncWith lets you specify how to combine new data from an API with existing data already in your sheet.

Service invoked too many times for one day: urlfetch

Google Sheets add-ons rely on certain Google services that have quota limits. Learn how to debug urlfetch quota problems.

Connect your Shopify account

How to connect additional Shopify accounts

Get a Shopify API key

Learn how to get a Shopify API key to access your merchant data with SyncWith.

Installation Trouble

If you're having trouble installing the SyncWith Google Sheets Addon, it can often be caused by having multiple Google Accounts, read on to see how to resolve this

How to use paginated APIs

Some APIs use pagination to limit the amount of data in each request. You have to make repeated calls to get each "page" of results. SyncWith can do this for you automatically. We support most pagination styles: page-based, offset/limit-based, URL-based and cursor-based.

Intro YouTube video

This video is a brief introduction to the SyncWith addon, showing how to connect to an API to pull data, how to expand nested JSON data using our preview tool, and then get it into Google Sheets

Cell references

Learn how to use the SyncWith Google Sheets add-on to import data from multiple requests using Cell References. Cell references save you time by enabling you to create powerful datasets driven from data in your sheet.