Configuring reports
Multiple filters/Regex
SyncWith only supports AND logic when you apply multiple filters in our add-on. Other common logics like OR or NOT are not currently supported but its a feature we hope to add in the future. Similarly it's not possible to use regex filters for Google Analytics at this time.Few readersHow to combine new data with your existing sheet: replace, append or synchronize
When you create a report using SyncWith, the entire API response is inserted into your Google Sheet. If you later refresh the report, there is new data from the API as well as existing data already in your sheet. SyncWith lets you specify whether or not to combine this new data with the existing data. If you choose to combine it, SyncWith also lets you specify how to reconcile existing rows with new rows. You can configure this behaviour in the Advanced section of your report: (https://stFew readersReordering columns
You can reorder columns in most of our natively supported integrations like Facebook Ads, Shopify and Google Analytics by dragging and dropping them in the SyncWith sidebar. Unfortunately this feature isn't yet available on custom API connections.Few readersScheduled report refreshes
At the surface setting up schedule refreshes with sync with is easy, simply choose your report, select schedule from the accordion menu and choose your desired refresh schedule (manual, daily or hourly): Data Recency Considerations For some data recency is very important - eg if you are a day trader you probably want your data refreshed more often and would likely use hourly For daily KPI checkFew readersMany Reports on a Single Google Sheet
SyncWith's default behaviour is to have each report load data onto its own sheet. This makes a lot of sense when you're pulling many rows of data with many columns and you want to use the power of sheets to: Sort the data Build filter views Create Pivot Tables Do vlookups to join data from another sheet Many times however you just want to load many small bits of data and assemble them on a spreadsheet like a dashboard. For this reason you want to specify having multiple reports placingFew readers
Troubleshooting
Service invoked too many times for one day: urlfetch
In order to promote efficient programming and fair use of shared resources, Google limits how often this function can be called. If your Google account, across all of its spreadsheets, formulas and scripts, calls this function more than 20,000 times per day, you will begin seeing errors in SyncWith. Most of the time, you do not need to worry about this. However, if you see error messages like: Service invoked too many times fSome readersSyncWith for Google Sheets won't load: drive.google.com refused to connect
If you open SyncWith and it is a blank gray screen, or you get an error drive.google.com refused to connect, it’s probably because you’re signed in to multiple Google accounts. To fix the issue, close SyncWith, sign out of your other Google accounts, use incognito browser, or sign in to your Google account in a different browser, then open SyncWith again. This is unfortunately caused by a bug in Google's Workspace Addon system, see https://developers.google.com/apps-script/guides/projectSome readersSyncWith for Google Sheets stuck loading
If the SyncWith Addon sidebar is stuck Initializing... this can often be caused by an incompatible browser extension. As a first step please try again using an Incognito window If it works using an Incognito window, then please review your browser extension(s) and see if disabling any of them helps. Addon stuck loading or initializingFew readersScript function __SW_GENERAL__OpenInSidebar_0 could not be found
If you encounter this error Script function SWGENERALOpenInSidebar0 could not be found it likely means you're attemping to use SyncWith in a Google sheet where it hasn't been installed yet. This can happen if you install SyncWith in a Google sheet, and use it there, and then make a copy of the Google Sheet. The solution is to install SyncWith on that new Google sheet: If you've used SyncWith before on other sheets (with your current Google account) then simply use the menu in GoogleFew readers
Advanced topics
How to use paginated APIs
We’re going to cover the common types of pagination in this tutorial including examples. Before we jump ahead if you’re reading this an you’re already using SyncWith, keep reading to see how we enable you to handle pagination with any API If you aren’t using SyncWith the tutorial will still be relevant as we review the different types BUT you might be interested in trying out our API connectors. SyncWith lets you: Sync thousands of APIs directly to Google Sheets (https://syncwith.com/gSome readersRefresh a report using a sheets function
To trigger a report to refresh, use the SWREFRESH(<address of top-left cell of report>) function. This function is similar to clicking on the Refresh button of a report to refresh it. Examples: Refresh a report in cell A1: SWREFRESH("A1") Use the CELL function to convert a cell reference into an address: SWREFRESH(CELL("address", A1)) Refresh a report in cell A1 in sheet MySheet: SWREFew readersCell references
Importing data with multiple API requests In this article we'll show how to use the SyncWith google sheets add-on to import data from multiple requests to one API using Cell References. This is a great time saver, enabling you to create powerful datasets driven from data in your sheet. Overview Here are the main steps you need to do: Install the SyncWith google sheets addon (https://gsuitFew readersManaging the timezone in SyncWith’s Google Sheets addon
How does SyncWith use Timezone When SyncWith inserts dates into your google sheets, it needs to use a timezone to indicate what day and time to put. The same moment can be represented by a different day and time in different timezones, for example as I right this its late at night on Thursday, but its likely already Friday in other parts of the world. Timezone Discrepancies A difference in timezone can be a common source of small differences between different systems, for example when comFew readers
Account management
Background access for Scheduled Reports
When using SyncWith for Google Sheets, we recommend that you authorize SyncWith for background access to your Google Sheets, to ensure that SyncWith can reliably access your Google Sheets(s) when running your scheduled reports in the background. When using SyncWith for Google Sheets, SyncWith can run your reports in the background, on a schedule, keeping them up to date for you automatically. By default SyncWith relies onPopularTeams
Features SyncWith has recently launched an initial features for Teams, so that you can collaborate with colleagues on reports and data sources: Being on a team lets you view and edit all team member’s reports on a given Google spreadsheet using the SyncWith addon for Google Sheets Being on a team also lets you access and use your team member’s connections to services like Facebook Ads, Google Analytics etc Limitations This is an initial small team release, missing many features youFew readersMoving reports to another SyncWith account
SyncWith is currently limited to a single account, tied to your Google Account. If you want to move a spreadsheet(s) and its report(s) from one account to another, you can use this process below. Before getting started be sure you have two Google accounts. The one that has the SyncWith reports that you want to copy, we’ll call that the source account, and the one you want to copy them to we’ll call that the destination account. Open the spreadsheet in Google Sheets Make a copy of it, usiFew readers