Configuring reports
How 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://stSome readersMultiple 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 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 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 readers
Troubleshooting
Connecting SyncWith to your Google Accounts
The first time that you use SyncWith to connect to Google Ads (or another Google service), you must explicitly give SyncWith permission by checking a checkbox. If you see the screen on the left when trying to connect SyncWith to your Google account, you must ensure all the empty checkboxes are checked before clicking Continue. Clicking Continue without checking all the checkboxes will result in a "The connection was denied" errPopularService 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 fPopularSyncWith for Google Sheets won't load: drive.google.com refused to connect
If you open SyncWith and it is a blank gray screen, get an error drive.google.com refused to connect or when you select one of the emails you are signed in and click continue but the screen won't go through, 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 aSome 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 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 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 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 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 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 readersTroubleshooting API requests
If you're using SyncWith for Google Sheet's API connector, to connect to a 3rd party's API by specifying the URL endpoint, and the method (Get/Post) etc, and you're having trouble figuring out what is going on, we recommend using the postman echo endpoints. To use these, find the right one based on your API's method eg GET or POST, and temporarily modify your settings in SyncWith to use the postman endpoint, then Postman will send backFew readers
Account management
Teams
Features SyncWith has recently launched our Teams feature, allowing you to collaborate with colleagues on reports and data sources. Being on a team allows you to: Share Reports View and edit all team member’s reports on a given Google spreadsheet using the SyncWith addon for Google Sheets Access and use your team member’s connections to services like Facebook Ads, Google Analytics etc Share Subscriptions Share your subscription with team members, so that plans and quota are shPopularMoving 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 readersBackground 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 onFew readersDiscontinuing Legacy Pricing Plans on Nov 1, 2024
SyncWith moved to usage-based pricing in Jan 2023 and we plan to discontinue the grandfathered legacy billing plans on Nov 1, 2024. If you are on a legacy plan, no action is required on your part. On Nov 1, 2024 your account will automatically be switched to the equivalently-priced usage-based billing plan. The new usage-based plans include a number of report refreshes each month. Check out our pricing page for all the details. If you getFew readers