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.
Alex Black
Many API Connections on a Single Google Sheet
Tutorial on how to ensure multiple API connections load data onto a single Google Sheet vs multiple sheets.
Chris Reid
Connecting SyncWith to your Google APIs
Connecting SyncWith to your Google accounts for the first time can be tricky. See a tutorial on how to connect it.
Colin Dellow
Scheduled API Refreshes
How to setup your scheduled api refreshes into Google Sheets with SyncWith
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.
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 with Binance
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.