Question 1

Connecting SyncWith to your Google Accounts

Accepted Answer

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" error message.

Checking all the checkboxes will ensure that you can use your data with SyncWith.

We apologize for the inconvenience. Because this screen is controlled by Google, it's beyond our control to make it more user-friendly.

If you are seeing errors related to permission denied or 403 Forbidden, please try re-connecting your Google account.

On a subsequent attempt to authorize the account, you may see a screen like:

In this case, there are no checkboxes to check, and you can immediately click `Co

Question 2

Connect your Shopify store

Accepted Answer

| To connect your Shopify store, click here.

This document explains how to connect your Shopify store to SyncWith using our Shopify Google Sheets integration or our Shopify Looker Studio connector. Shopify requires us to send you to their app store to install our app. This can make things a little tricky for you, but we've tried to make it as easy as possible.

Start by going to the SyncWith listing in the Shopify app store.
Click Install

Log in to Shopify if prompted
You will see a list of your stores. Select the store you wish to connect to SyncWith

Shopify will ask you to confirm your choice, click Install app

The SyncWith app will open in your store, and show that you've just connected.

If you were connecting from SyncWith for Google Shee

Question 3

Service invoked too many times for one day: urlfetch

Accepted Answer

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 for one day: urlfetch

Then you are exceeding this limit. The only solution is to reduce your usage of this service and wait a day for the quota to reset.

Common culprits that can cause high usage of the urlfetch service are:

ImportAPI formula function
ImportJSON formula function
UrlFetchApp.fetch AppsScript function

Please check your spreadsheets for excessive use of these functions and reduce them where possible.

Step 1: What scripts or add-ons are using my quota?

Visit https://script.google.com/home/executions to see all recent Google Apps Script functions that have run. Well-behaved scripts should only run a handful of times per hour at most.
Visit https://script.google.com/home/executions
Review the scripts/tools that are running
Identify any that are running very often that are not SyncWith (which might show up as API Pipeline)
Stop or remove any tools using too much quota
Wait 24 hours for your quota to reset

Step 2: Ensure your Google S

Question 4

Teams

Accepted Answer

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 shared among the team
Only the team admin can edit/update the subscription

Limitations

We're continually improving the teams feature. These are some known limitations:

Access Controls

Team members have full access to all reports. They can:

Create, edit and delete other team member's reports
Access data sources and connections. For example, a team member could create a report using the Facebook Ads credentials you have linked with SyncWith

So please only invite team members you trust.

However, note that team members can only access reports in sheets they have editor access to.

Multiple Teams

Although you can join multiple teams, the last team you join will be your "primary" team. When you leave a team, the last team you joined will become the primary team.

Your primary team manages your subscription and refresh quota. This means that when you join a team, the refresh quota available to your reports may decrease if the team is on a hobby plan. Leaving the team w

Question 5

Connecting to Postgres or MySQL

Accepted Answer

SyncWith has built in Google Sheets integrations for Postgres or MySQL databases. You can run arbitrary SQL and have it import directly into your Google Sheet.

Connection Strings

The easiest way to connect to your database is with a connection string. Most web hosting companies will provide you with a connection string in the admin UI.

It will look something like postgres://YourUserName:YourPassword@YourHostname:5432/YourDatabaseName

Static IP Addresses

If your database is protected by network security, you can whitelist SyncWith’s static IP addresses to enable SyncWith to access your database securely:

3.227.95.35
34.199.138.158

Common Errors

You may need to adjust settings on your database server to permit SyncWith to communicate with it.

ENOTFOUND

ENOTFOUND often means that you are using an internal hostname. SyncWith needs an external hostname.

Internal hostnames often look like:

192.168.x.x
172.30.x.x
justahost (an external hostname include a domain, for example: ahost.domain.com)

You may need to ask your hosting provider for assistance.

ETIMEDOUT

ETIMEDOUT often means that your database is blocking us at the network level via firewall rules. You will need to permit access to SyncWith’s static IP addresses (see above).

ECONNREFUSED

ECONNREFUSED means the connection was refused, this c

Question 6

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

Accepted Answer

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:

Replace contents of sheet

This is the default behaviour. When Replace contents of sheet is selected, any previous data from the connection is first erased from the sheet. Once the sheet has been cleared, the contents of the API response are inserted.

Append new rows to end of sheet

When Append new rows to end of sheet is selected, any previous data is left as-is. The contents of the API response are inserted immediately after the last row of data.

This mode is useful for accumulating data over time. For example, you might use the SERPHouse API to fetch the top organic results for a search term:

In append mode, each time you refresh, the current set of organic results will be snapshotted and appended to your sheet. If you configured this connection to run every day, you would then be able to mon

Frequently Read Articles

Browse All Categories