blog post

How to Get Data from Instagram to Google Sheets

Florian Cabirol
January 30, 2024
How to Get Data from Instagram to Google Sheets

Quick steps to create a Instagram report with Google Sheets:

You can easiliy create a Instagram report following this step :

  1. Get informations from the data integration from our Instagram connector.
  2. Create a source on catchr.io.
  3. Download our Google Sheets extensions.
  4. Configure and run your request
If you need more informations, you can follow the tutorial.

How to install Google Sheets Catchr Add-on.

To start exporting your Instagram data to Google Sheets, you need to install the Catchr add-on. You currently have two options :

Option A: Via the marketplace:

  1. Visit the Catchr Add-on page on the Google Workspace Marketplace and click "Install."
  2. Grant the necessary permissions for the add-on.
  3. Upon successful installation, open a Google Sheets to proceed.
Connect Google Sheet to Facebook Ads
Install Catchr Google Sheets Add-on

Option B: Directly within a Google Sheets:

  1. Open a new Google Sheets.
  2. In the top menu, click "Extensions", then hover over "Add-ons" and select "Get add-ons."
  3. Search for "Catchr" and choose "Catchr - data connector."
  4. Click "Install" and grant the required permissions.
  5. Close the installation pop-up when completed.
  6. Start using the Catchr add-on.
Install Catchr Add-on for Google Sheets
Install Catchr Add-on for Google Sheets

Once you have installed the add-on, you can start making requests.

The tutorial

Quick steps to create a Instagram report with Looker Studio:

You can easiliy create a Instagram report following this step :

  1. Get informations from the data integration from our Instagram connector.
  2. Create a datasource and new report on Looker Studio.
  3. Choose your metrics and dimensions.
  4. Use charts with your metrics and dimensions.
If you need more informations, you can follow the tutorial. You can also find a template for Instagram at the end of the page.

The tutorial

Quick steps to create a Instagram report with PowerBI:

You can easiliy create a Instagram report following this step :

  1. Get informations from the data integration from our Instagram connector.
  2. Create a source on catchr.io.
  3. Configure your request on the PowerBI request manager.
  4. Copy the given URL in PowerBI
If you need more informations, you can follow the tutorial. You can also find a template for Instagram at the end of the page.

The tutorial

To get the most out of your social media campaigns, you need to know a lot about your audience and how your Instagram posts are doing. For you, digital marketers who are in charge of multiple channels like Instagram, it's important to put this information into organized systems like Google Sheets so that they can analyze it better. 

In this guide, we'll look at how to use the smart Catchr add-on to get all your data from Instagram to Google Sheets quickly. With step-by-step instructions and expert tips, you'll be able to set up automated reports quickly and focus on what really matters: your marketing strategy.

Why You Need to Use Google Sheets with Instagram

Google Sheets is a great way to organize information because your entire team can work on it, access it from the cloud, and use it on multiple platforms. When you integrate it with marketing platforms like Instagram, you can get a clear picture of how well your digital strategy is working. 

But there are some other major benefits:

Transparency across teams: By centralizing Instagram data in one location that everyone has access to, all team members remain informed about the data's progress at all times. 
Updates in real time: Your data analytics are always the most up-to-date because they are automatically refreshed. 
Easily customizable reports: The ability to easily update formulas helps users tailor reports according to prospects' needs or your' preferences.

With that in mind, it's clear that using Google Sheet is a no-brainer.

Step 1: Set Up a New Query in Google Sheets

After successful installation:

1. Click on Add-ons, which can be seen listed within your spreadsheet's top-left corner. 
2. Navigate through the pop-up menu until you find “Catchr - Data connector". Choose "Launch"
3. A sidebar will appear, showing all your current available queries for the Google Sheet. Click on “New query”. Find and click on “Instagram”
4. If no account listing shows up initially, create one yourself using any plus button across the displayed selections.

Open the Catchr add-on in Google Sheet.
Open the Catchr add-on in Google Sheet.

Step 2: Select your Instagram accounts.

You need to select the Instagram account(s) you want to work on. You can select one or more accounts. Our system will aggregate your data automatically based on the dimensions. 

Select your Instagram account
Select your Instagram account

Step 3: Choose your metrics and dimensions.

This is where things might get interesting, because you can select any fields you want. On the metrics tabs, you can find metrics like “profile followers” or “media impressions.” 

Metrics tabs for Instagram
Metrics tabs for Instagram

On the dimensions tab, you could choose the dimension you want to use to breakdown your data. It could be “Day”, “Media Type” or whatever you want. 

Dimension choice for instagram
Dimension choice for Instagram

Step 4: Choose your date range.

On the Date Range tab, there is a selector that lets you choose any time range that makes sense for your data. Some presets are available by default, like “Today”, “Yesterday”, etc. But you could also provide a custom start and end date. 

Date range selection
Date range selection

Step 5: Add some filters.

Sometimes you want to filter your data to get only the information you need. By way of example, if you want to get only the videos from your Instagram profiles, you could easily add a filter from the filter tab. 

Just select “Media Type” in the selector, choose the “Equals” operator, and put “Video” in the field. 

Filter by media type on Instagram
Filter by media type on Instagram

Step 6: Schedule Automatic Refreshes & Combining Rows

You can set up a query schedule to automatically update your data every week, every day, or even every hour. You can customize this in the Options tab. Activate "append rows" to add new data beneath old while preserving historical context. Alternatively, use "Combine rows" as it updates the entire range without losing vital prior comparisons!

Schedule and combine your data

Once ready, hit “Get Data".

Your data will be displayed in the spreadsheets automatically. 

An Example Data Report for Instagram Optimized Using the Catchr Add-on

Let's say you're tasked with monitoring the success of a recent Instagram post. We will build this report easily with the Google Sheets add-on. Follow the following steps:

  1. Let's start by creating new sheets. You can also go directly to "sheets.new", which will create a Google Sheet for you. 
  2. Launch the Catchr add-on and create a new query. Click on “Instagram” and select the desired accounts. 
  3. Choose “Media Reach” in the metrics tabs and “Media Id” in the dimensions tabs. 
  4. Select “Last Month” as a date range. 
  5. And you are done. Just click on “Get data” now. 

You will see something like this:

Result for Instagram data

Congrats, you have created your first report with Catchr. You could now improve or use other report to build a beautiful dashboard for your business. 

Bonus : Your free Instagram Followers Template

In this Instagram template, you will find all the metrics and dimensions you would need to get a better view of your data.

If you need more templates, you could look at our looker studio template gallery.

Bonus : Your free Instagram Followers OverviewTemplate for PowerBI

In this Instagram template, you will find all the metrics and dimensions you would need to get a better view of your data thank to our integrations.

If you need more templates, you could look at our PowerBI template gallery.

Unlock Insights with Style!

Transform your marketing data into stunning dashboards.

Integrate, visualize, and impress with Catchr's seamless dashboards. Elevate your data game now!
Build your first report
14 days free-trial - No credit card required 🎉

More blog post about Instagram

Explore your Instagram marketing KPI in PowerBI : How-to, templates and metrics

Unlock the power of Instagram marketing analytics with PowerBI through this detailed tutorial. Learn how to connect your Instagram account to PowerBI using Catchr, enabling you to import and visualize key Instagram metrics. Discover how to create insightful dashboards in PowerBI, leveraging Instagram data for comprehensive analytics and strategic decision-making. This guide provides step-by-step instructions for integrating Instagram with PowerBI, offering marketers a powerful tool for data-driven storytelling and campaign analysis.

Florian Cabirol

Connect Instagram to Looker Studio : How-to, templates and metrics

Learn how to use Looker Studio with your Instagram data, get a free template and adapt it to your need quickly!

Johan Chemin

How to Get Data from Instagram to Google Sheets

Discover how you can efficiently get data from Instagram campaigns into Google Sheets with the powerful Catchr Add-on. Automate your reports quickly & effectively!

Florian Cabirol

Top KPIs You Need to Track for Instagram in 2023

Learn how to improve your Instagram marketing strategy by tracking essential KPIs like reach, engagement, and sales. Access your analytics and start monitoring your progress now.

Florian Cabirol