SyncWith Analytics Beta

Details on SyncWith’s Analytics beta and how to participate

Google Sheet Salesforce Connector

Salesforce Google Sheet connector overview, including how to request data via API or SOQL and keep your data synched to Google Sheets.

Export Data in Salesforce

Export Salesforce data into your platform of choice as a backup or to work with your CRM data in ways you couldn’t otherwise.

Salesforce Excel Connector

Connect salesforce to excel and export and sync contacts, opportunities and leads to excel.

Facebook Integration for Excel

Track your facebook ads manager spend and build the best ads report template in Excel to track and refresh your campaign data.

Data Studio: “You need access” / “Access denied”

Learn how to trouble shoot an access denied error from SyncWith’s Data Studio connector.

Facebook Airtable Integration

Connecting facebook ads and other facebook APIs to Airtable via the Facebook Airtable integration.

Hubspot Google Sheets Integration

Creating a postgres to google sheets connection, using the SyncWith PostgreSQL Google Sheets integration. Move data into Google Sheets from your Postgres database and filter, graph, pivot the data using Sheets.

PostgreSQL to Google Sheets

Creating a postgres to google sheets connection, using the SyncWith PostgreSQL Google Sheets integration. Move data into Google Sheets from your Postgres database and filter, graph, pivot the data using Sheets.

MySQL to Google Sheets

Creating a Google Sheets MySQL connection, using the SyncWith MySqL Google Sheets integration. Move data into Google Sheets from your MySQL database and filter, graph, pivot the data using Sheets.

Connect Facebook Ads to Google Data Studio

Connecting Facebook to Google Data Studio to analyze and track your ad campaigns.

SyncWith - Any API to Airtable

Overview of SyncWith’s Google Sheets addon to enable any API to be synced to Airtable

Google Analytics UA vs GA4

Learn more about Google Analytics 4 (GA4), it’s pros and cons, why and how it differs from GA3 and how to take advantage of it.

Mailchimp Marketing API

The mailchimp marketing api endpoints allow you to monitor your activities including your email campaigns.

Google Ads API

Quick overview of the Google Ads API and the ability to live test the API.

BeMob API

Overview of the BeMob API and how to push your ad tracking and affiliate metrics into separate data sources such as Google Sheets for analysis

HubSpot CRM API

Learn about the HubSpot CRM API (api.hubapi.com) and all the various endpoints available to filter, sort, search, update and create HubSpot objects: contacts, deals, products, tickets, etc.

YouTube Analytics API

Get detailed engagement metrics for your YouTube channels and video sync’d from the YouTube API to your platform of choice.

GoHighLevel API Overview

Overview of the the HighLevel API and how to sync you GoHighLevel data to google sheets, excel and other data destinations.

Facebook Ad Strategies and Funnels

In depth guide to creating successful ad funnels with Facebook ads - tracking performance and scaling campaigns.

How to Drive Good ROAS on Facebook

Overview of return on ad spend and how to track, measure and increase ROAS of your Facebook Ads

JSON Placeholder API

JSON Placeholder API is perfect for when you need placeholder json. If you need fake json for users, posts or todos this the right placeholder api.

Keepa API

Utilize the keepa api, the amazon price tracker to pivot, filter and analyze price data

SaaS APIs

Overview of popular SaaS APIs including Zendesk, Trello and Pipedrive

Report which web pages get the most traffic and highest engagement

Overview of how to track web page engagement in Google Sheets.

Connect GA4 to Google Sheets

Overview of how to connect and sync Google Analytics v4 to Google Sheets

Connect Google Analytics to Google Sheets

Overview of how to connect and export Google Universal Analytics data to Google Sheets via the Google Analytics v3 API.

Shopify Admin API GraphQL Overview

Overview of how to connect to the Shopify Admin API via the GraphQL endpoint with a focus on retrieving orders

Connect Facebook Ads to Google Sheets

Overview of how to connect and export facebook leads and facebook ad data to Google Sheets via the facebook API.

Connect Shopify Products to Google Sheets

Overview of how to connect and export Shopify products to Google Sheets

Facebook to Google Sheets Guide

Overview of SyncWith’s Facebook APIs, templates and general guidelines on facebook audience and ad analytics to Google Sheets.

Connect Instagram Post Insights to Google Sheets

Overview of how to connect and export Instagram post data to Google Sheets via the Instagram Post Insights API.

Connect Shopify Orders to Google Sheets

Overview of how to connect and export your Shopify orders to Google Sheets

Connect Facebook Page Insights API to Google Sheets

Overview of how to connect and export facebook leads and facebook ad data to Google Sheets via the facebook API.

Track Stripe MRR in Google Sheets

Learn how to load your subscriptions into Google Sheets to calculate your MRR in your currency of choice

Calculate Rolling Averages with Array Formulas in Google Sheets

Utilize Google Sheets ArrayFormula and Sumif to calculate rolling sums and moving averages. Specifically how to track your MRR, daily MRR growth and MRR growth on a moving average basis.

How to re-connect your Data Studio source

This article explains how to troubleshoot a broken Data Studio data source.

Facebook Ads API

Our comprehensive guide to how to use the Facebook ads API. Learn how to get data from the Facebook insights API, the ads API and the leads API.

Top Pages in Google Search Console

Use Google Analytics to understand where you’re getting traffic from and to which pages

How to use the Mailchimp Campaign Open Report

Learn how to use SyncWith to access your Mailchimp campaign open report.

Update your Shopify inventory availability by SKU

Get a template spreadsheet that shows how to use the Shopify API to adjust inventory levels at your store’s locations.

Track Pinterest ad account metrics

Learn how to use the Pinterest API to track your paid Pinterest ad performance.

Export LinkedIn analytics: followers, page views and shares

Learn how to use the LinkedIn API to export your organization’s number of followers, page views and shares.

Get your LinkedIn Organization URN

Many LinkedIn API calls require an ID known as your organization’s URN. Learn how to find your organization’s URN.

Get YouTube video views by traffic source type

Drill into the number of views each of your videos gets by the source of the traffic, for example advertising, external links and embeds.

Export Sales Orders from Unleashed

Learn how to export your sales orders from Unleashed to Google Sheets.

Export tickets from a Zendesk view

Zendesk can organize tickets into views; learn how to use SyncWith to export only tickets from the view you specify.

Get Tweet Engagement Metrics from Twitter API

Learn how to use the Twitter API to track tweet impressions, profile visits and link clicks.

Export data from Zoho Analytics API

Learn how to export data from Zoho Analytics API into Google Sheets.

How to find YouTube Channel ID

Many YouTube API calls require the YouTube channel ID. Learn how to find the channel ID for any YouTube channel.

Get YouTube subscriber counts and view counts into Google Sheets

Learn how to export statistics about YouTube channels, including subscriber, video and view counts, into Google Sheets.

Get a Wild Apricot access token

Wild Apricot’s API requires you to create an API key, and then exchange the API key for an access token. Learn how to get your access token.

Export your Facebook Ad Campaigns

Export your Facebook ad campaign configuration, including budget and remaining spend limits.

Export your Facebook Ad Creatives

Export metadata about your Facebook ad creatives, for example, to relate ad spend to Facebook post performance.

Track your Shopify inventory by SKU

Use Shopify’s GraphQL API to improve your business processes by automating reporting of your inventory in stock, broken out by SKU and location.

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.

Google Analytics SEO Tracker Template

Utilize Google Analytics data to show trends for the top landing pages receiving traffic from Google organic search.

Connecting WooCommerce Orders to Google Sheets

Export and sync your WooCommerce customers, orders, and more to Google Sheets using the WooCommerce API with the SyncWith Google Sheets addon

SEO KPIs: Landing Page Analysis

Analyzing landing pages with Google Search Console to improve SEO performance

Connecting Notion tables to Google Sheets

Create a live connection from a Notion table(s) to Google Sheets using the SyncWith Google Sheets addon and the Notion API

Facebook Page Metrics into Google Sheets

How to get your Facebook page(s) metrics including likes, comments, engagements, clicks, impressions into Google Sheets using the Facebook Graph API

Mailchimp campaign metrics into Google Sheets

In this tutorial we'll show how to track your Mailchimp campaign metrics including open rate, click through rate and more

Get Twitter user followers count into Google Sheets

Using the SyncWith Google Sheets Addon we can pull metrics from the Twitter API including follower count, following count and more, for one username, or a list of usernames from Google Sheets.

Listing Xero invoices

Xero requires a special header in most API requests. This tutorial tells you how to find your Xero-Tenant-Id value and call the Invoices API.

Creating Marketing KPIs

Beginners reference for setting up and creating marketing KPIs in Google Sheets using SyncWith.

Get student grades from Google Classroom

Learn how to export a spreadsheet of student grades from your Google Classroom account.

Export YouTube video engagement stats to Google Sheets

Do you run a YouTube channel? You can use the YouTube API to export all your videos and their likes, views, comment counts etc to Google Sheets using the SyncWith Addon

Get a Shopify API key

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

Pulling Airtable records into Google Sheets

Airtable is a popular app for managing tables of data. In this tutorial we'll show how to pull any of your tables into Google Sheets, keeping them in sync.

SEO: Get your top landing pages from search

Use Google Analytics v3 to understand your top landing pages from Google organic search.

Google Search Console - Queries

Here we'll show how to use the Google Search Console API to pull a list of all your site's queries to get their clicks, impressions, CTR and position. We'll also show how to get stats for a single query, which you can then use with Cell References to pull stats on just the queries you care about.

YouTube Analytics in Google Sheets

The YouTube Analytics API lets you pull analytics data into Google Sheets to automate complex reporting tasks, build custom dashboards and more. You can pull data about a video channel, to find out key metrics including views, comments, likes, minutes watched, view duration, subscribers gained or lost, and you can segment it by video, or by time period such as day, week, month etc.

Get Salesforce Leads

Sync your salesforce leads with google sheets on a schedule using the salesforce API, Syncwith and SOQL (Salesforce Object Query Language)

Export a YouTube Playlist to a Spreadsheet

Do you have large YouTube playlist(s)? You can use the YouTube API to export your playlist of videos or songs to CSV or Google Sheets. We'll show how to do this, and how to have a live updating export in Google Sheets.

Instagram Followers Count

Do you want to stay up to date with your follower count on Instagram? You can use SyncWith to automatically pull your follower count and other key metrics into Google Sheets, giving you a live view of your metrics, enabling you report on it or even build it into a dashboard.