Here you can find tutorials about using SyncWith's Google Sheets Addon, and articles showing how to get useful data out of 3rd party apps and services.
SyncWith Analytics Beta
Details on SyncWith’s Analytics beta and how to participate
Chris Reid
Salesforce Excel Connector
Connect salesforce to excel and export and sync contacts, opportunities and leads to excel.
Chris Reid
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.
Chris Reid
Data Studio: “You need access” / “Access denied”
Learn how to trouble shoot an access denied error from SyncWith’s Data Studio connector.
Colin Dellow
Facebook Airtable Integration
Connecting facebook ads and other facebook APIs to Airtable via the Facebook Airtable integration.
Chris Reid
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.
Chris Reid
Connect Facebook Ads to Google Data Studio
Connecting Facebook to Google Data Studio to analyze and track your ad campaigns.
Chris Reid
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.
Chris Reid
Mailchimp Marketing API
The mailchimp marketing api endpoints allow you to monitor your activities including your email campaigns.
Chris Reid
Google Ads API
Quick overview of the Google Ads API and the ability to live test the API.
Chris Reid
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
Chris Reid
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.
Chris Reid
YouTube Analytics API
Get detailed engagement metrics for your YouTube channels and video sync’d from the YouTube API to your platform of choice.
Chris Reid
GoHighLevel API Overview
Overview of the the HighLevel API and how to sync you GoHighLevel data to google sheets, excel and other data destinations.
Chris Reid
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.
Chris Reid
Keepa API
Utilize the keepa api, the amazon price tracker to pivot, filter and analyze price data
Chris Reid
SaaS APIs
Overview of popular SaaS APIs including Zendesk, Trello and Pipedrive
Chris Reid
Report which web pages get the most traffic and highest engagement
Overview of how to track web page engagement in Google Sheets.
Chris Reid
Connect GA4 to Google Sheets
Overview of how to connect and sync Google Analytics v4 to Google Sheets
Chris Reid
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.
Chris Reid
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
Chris Reid
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.
Chris Reid
Connect Shopify Products to Google Sheets
Overview of how to connect and export Shopify products to Google Sheets
Chris Reid
Facebook to Google Sheets Guide
Overview of SyncWith’s Facebook APIs, templates and general guidelines on facebook audience and ad analytics to Google Sheets.
Chris Reid
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.
Chris Reid
Connect Shopify Orders to Google Sheets
Overview of how to connect and export your Shopify orders to Google Sheets
Chris Reid
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.
Chris Reid
Track Stripe MRR in Google Sheets
Learn how to load your subscriptions into Google Sheets to calculate your MRR in your currency of choice
Chris Reid
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.
Chris Reid
How to re-connect your Data Studio source
This article explains how to troubleshoot a broken Data Studio data source.
Colin Dellow
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.
Colin Dellow
Top Pages in Google Search Console
Use Google Analytics to understand where you’re getting traffic from and to which pages
Chris Reid
How to use the Mailchimp Campaign Open Report
Learn how to use SyncWith to access your Mailchimp campaign open report.
Colin Dellow
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.
Colin Dellow
Track Pinterest ad account metrics
Learn how to use the Pinterest API to track your paid Pinterest ad performance.
Colin Dellow
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.
Colin Dellow
Export Sales Orders from Unleashed
Learn how to export your sales orders from Unleashed to Google Sheets.
Colin Dellow
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.
Colin Dellow
Get Tweet Engagement Metrics from Twitter API
Learn how to use the Twitter API to track tweet impressions, profile visits and link clicks.
Colin Dellow
Export data from Zoho Analytics API
Learn how to export data from Zoho Analytics API into Google Sheets.
Colin Dellow
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.
Colin Dellow
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.
Colin Dellow
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.
Colin Dellow
Export your Facebook Ad Campaigns
Export your Facebook ad campaign configuration, including budget and remaining spend limits.
Colin Dellow
Export your Facebook Ad Creatives
Export metadata about your Facebook ad creatives, for example, to relate ad spend to Facebook post performance.
Colin Dellow
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.
Colin Dellow
How to get a Notion API key
Learn how to get an integration API key to access your Notion database.
Colin Dellow
Google Analytics SEO Tracker Template
Utilize Google Analytics data to show trends for the top landing pages receiving traffic from Google organic search.
Colin Dellow
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
Alex Black
SEO KPIs: Landing Page Analysis
Analyzing landing pages with Google Search Console to improve SEO performance
Chris Reid
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
Alex Black
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.
Alex Black
Get student grades from Google Classroom
Learn how to export a spreadsheet of student grades from your Google Classroom account.
Colin Dellow
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
Alex Black
Get a Shopify API key
Learn how to get a Shopify API key to access your merchant data with SyncWith.
Colin Dellow
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.
Alex Black
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.
Alex Black