Salesforce SOQL Query Tool

Quick online query tool to run your SOQL query and export to CSV or a Google Sheet

Free Sales Rep Tracking

Overview of how to track sales reps with data synched daily on rep activity. An example and template provided using Google Sheets and Salesforce data.

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.

Create List of all Salesforce Reports

Export a list of all salesforce reports with ID, name, description

Export Report from Salesforce

Export your salesforce report to google sheets, airtable and excel and keep them synced daily.

Export SOQL Query to Excel & Google Sheets

Frustrated that you can’t export SOQL queries from the Salesforce Developer Console? We’ll show you how to sync to CSV, Excel, Sheets and more including a live tool to do your exports.

How to get all field names of an object in Salesforce

Quick tutorial on how to get all the field names of an object using SOQL and a free spreadsheet tool to easily pull the fields of an object.

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.

Connect Excel to MySQL

Integrate MySQL for excel and sync your database records into excel for analysis. Easily refresh the data and sync multiple MySQL tables.

Airtable Google Analytics Integration

Connecting and syncing Google Analytics (ga3 and ga4) to Airtable via the Airtable Google Analytics integration.

Airtable Google Ads Integration

Connecting and syncing Google ads data to Airtable via the Airtable Google Ads integration.

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

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

Airtable Hubspot Integration

Connecting Hubspot CRM to Airtable, including contacts, deals and companies via the Airtable Hubspot integration.

Facebook Airtable Integration

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

Export Hubspot Tasks

How to export hubspot CRM tasks to your destination of choice: csv, excel and google sheets, airtable and more.

Export Hubspot Companies

How to export hubspot CRM companies to your destination of choice: csv, excel and google sheets, airtable and more.

Export Hubspot Deals API

How to export hubspot CRM deals to your destination of choice: csv, excel and google sheets, airtable and more.

Export Hubspot Contacts

How to export hubspot CRM contacts to your destination of choice: csv, excel and google sheets, airtable and more.

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.

Connect Stripe to Google Data Studio

Connect stripe to Google data studio to analyze your transactions. Report on recent charges and track the growth of your business.

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 Shopify to Google Data Studio

Connect Shopify to Google Data Studio to analyze recent orders and report on the growth of your ecommerce store.

Connect Facebook Ads to Google Data Studio

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

SyncWith - Any API to Power BI

Overview of SyncWith’s free Power BI connector.

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

Facebook Ads Connector for Power BI

Learn how to install and use the Facebook Ads connector for Microsoft Power BI.

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

Metaweather API

Learn how to use the free weather api - metaweather. Create a weather dashboard and meta weather api alternatives.

SaaS APIs

Overview of popular SaaS APIs including Zendesk, Trello and Pipedrive

Yahoo Finance API Guide & Examples

Overview of the Yahoo Finance API including examples, live testing and endpoint overviews

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 API to Google Sheets

Overview of how to connect and export Shopify products to Google Sheets via the Shopify API.

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 API to Google Sheets

Overview of how to connect and export Shopify order to Google Sheets via the Shopify API.

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.

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.

API Sports Google Sheets Overview

General overview of moving data from the API Sports api into Google Sheets

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.

CoinGecko USD Coin Tracker Template

Track up to 15 coins with detailed information including price, pricing trends for the last year, 7d charts all in Google sheets

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.

Current Covid19 stats by country into Google Sheets

Here we'll use the free Covid19 API to get current stats on the coronavirus worldwide, by country, into Google Sheets, and using the SyncWith Google Sheets Addon it will be kept up to date automatically!

Free weather data by date via API in Google Sheets

Using the free API from MetaWeather we'll show you how to pull detailed weather data for a date in the past or future

Getting the weather forecast into Google Sheets

Using the free API from MetaWeather we'll show you how to get the weather forecast for the next 5+ days into Google Sheets and keep it up to date automatically.

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.

Yahoo Finance - Major Holders Breakdown

Using Yahoo Finance's undocumented API you can get a lot of information about a particular stock. If you want to get the Major Holders breakdown, to see what % of the shares are owned by insiders and institutions, you can request the module majorHoldersBreakdown

Yahoo Finance - Getting Balance Sheet data

Learn how to use Yahoo Finance's undocumented API. Specifically we'll show how to use the SyncWith Addon to extract Balance Sheet financial data for any public company based on their stock ticker.

Get Salesforce Leads

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

Get daily weather from OpenWeatherMap

Get a live weather forecast for the next 7 days in Google Sheets using the OpenWeatherMap free API.

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.