How to Connect Instagram Insights to Google Sheets

Published: January 13, 2024 - 4 min read

Julian Alvarado

Instagram Insights offers invaluable data to understand audience engagement and campaign performance. However, extracting and utilizing this data effectively can be challenging.

In this blog, we’ll explore two options for connecting methods to connect Instagram Insights to Google Sheets: Coefficient and Google Sheets App Scripts.

Note for Excel users: Coefficient makes it just easy to connect  Instagram Insights to Excel. Download our Excel add-in to try it out!

Connect Instagram Insights to Google Sheets: 2 Methods

1. Coefficient – Simple No-Code One-Click Connector

Coefficient is a free Google Sheets add-on that allows you to easily integrate live data from business platforms directly into your spreadsheet.

By integrating Instagram Insights data into Google Sheets, marketers can centralize their reporting in a few easy clicks.

Before getting started, you must first install Coefficeint.

Open a new spreadsheet.

Navigate to the top menu and click ‘Extensions’ -> ‘Choose Add-ons’ -> ‘Get add-ons.’

This will open up the Google Workspace Marketplace.

Accessing the Extensions menu in Google Sheets to add new add-ons.

Search for “Coefficient” in the search bar and select the first app that appears in the search results.

Searching for the Coefficient add-on in Google Sheets.

Accept the prompts to install.

Confirmation dialog for installing Coefficient in Google Sheets

Once installation is finished, return to Extensions on the Google Sheets menu and Launch Coefficient.

Launching the Coefficient extension from the Google Sheets menu.

Coefficient will appear in the sidebar of your spreadsheet.

Click ‘Import from…’

Selecting the 'Import from…' option in Coefficient for Google Sheets.

Scroll down and select Instagram Insights as your data source.  

Choosing Instagram Insights as a data source in Coefficient

Coefficient will prompt you to grant it access to your Instagram Insights account.

Click ‘Authorize’ to proceed.  

Authorizing access to Instagram Insights account in Coefficient

Follow the prompts to complete authorization.

Once connected, navigate back to the Coefficient menu > ‘Import from…’ > ‘Instagram Insights’

Select ‘Start from Scratch.’

Selecting 'Start from Scratch' in Coefficient for custom data import

Select your company account from  Coefficient’s Import Preview menu and click ‘Next’ to continue.

Selecting a company account in Coefficient's Import Preview menu

Select an insight from the menu. In this example, we chose Page Engagement.

Click ‘Next’ to continue.

Coefficient Excel Google Sheets Connectors
Try the Free Spreadsheet Extension Over 314,000 Pros Are Raving About

Stop exporting data manually. Sync data from your business systems into Google Sheets or Excel with Coefficient and set it on a refresh schedule.

Get Started
Choosing the Page Engagement insight in Coefficient's import options

Now you can customize your import by adding filters, setting row limits, or pivoting your data for varied perspectives.

Customizing import settings in Coefficient, adding filters and setting row limits

After customizing your import, click the ‘Import’ button in the upper right corner to finish.

Clicking the 'Import' button in Coefficient to finalize data import to Google Sheets.

 Your data will automatically populate your spreadsheet.

Instagram Insights data automatically populating in Google Sheets.

Pros

  • No Code Required: Simply install Coefficient to your spreadsheet and connect it to  Instagram Insights. It’s user-friendly and doesn’t demand any coding expertise.
  • Saves Time: Connecting Instagram Insights to Google Sheets or Excel is quick and straightforward, eliminating manual data transfers and saving valuable hours.
  • Live Data: Changes in your  Instagram Insights data are instantly reflected in your spreadsheet, ensuring you always work with up-to-date information for better reporting and analysis.

Cons

The only downside to Coefficient is that any scheduled automations are not free forever.

However, its pricing plans are affordable, and its benefits far outweigh the app’s costs.

2. Google Apps Script

Those with coding skills have the option to use Google Apps Scripts to connect Instagram Insights to Google Sheets.

What you’ll need:

  • Basic understanding of JavaScript.
  • An Instagram Access Token, obtained by creating an app on the Facebook Developer site.
  • The Instagram API endpoint URL for fetching Insights data.

Navigate to Google Sheets and on ‘Extensions’ > ‘Apps Script.

Accessing the Apps Script editor from the Google Sheets Extensions menu

The Apps Script editor will open in a new window.

Pasting a custom script into the Google Sheets Apps Script editor for Instagram Insights integration

Copy and paste the following script into the Apps Script editor:

function importInstagramData() {  var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(“Instagram Insights”);  var accessToken = ‘YOUR_INSTAGRAM_ACCESS_TOKEN’;  var apiURL = ‘https://graph.instagram.com/me/insights?access_token=’ + accessToken;  var response = UrlFetchApp.fetch(apiURL);  var json = response.getContentText();  var data = JSON.parse(json);  data.data.forEach(function(insight) {    sheet.appendRow([insight.name, insight.period, insight.values[0].value]);  });}

Script Breakdown:

  • The script targets a specific sheet tab for data storage.
  • Replace ‘YOUR_INSTAGRAM_ACCESS_TOKEN’ with your actual Instagram Access Token.
  • The script automatically retrieves and adds Instagram Insights data to your Google Sheet.
Running the custom script in Google Sheets Apps Script editor for Instagram data import.

Save the script and run it by clicking the play button in the Apps Script editor.

Setting up automatic data update triggers in Google Sheets Apps Script for Instagram Insights.

To schedule automatic data updates, use the ‘Triggers’ option in the Apps Script editor to set regular intervals (e.g., daily).

Pros

  • Google Apps Script is free.
  • There’s a robust community for support, script sharing, and troubleshooting.

Cons

  • Google Apps Script requires a good grasp of coding for basic functions.
  • There are daily quotas on automation capabilities.
  • Scaling and managing scripts across multiple sheets or users can be complex.

Connect Instagram Insights to Google Sheets in a Few Clicks

Integrating Instagram performance metrics into Google Sheets allows marketers to track and analyze their engagement and conversion metrics easily.

And with Coefficient, you can do it in just a few clicks. Get started for free today to try it for yourself.

Set Spreadsheet Data on Refresh

Try the Spreadsheet Automation Tool Over 300,000 Professionals are Raving About

Tired of spending endless hours manually pushing and pulling data into Google Sheets? Say goodbye to repetitive tasks and hello to efficiency with Coefficient, the leading spreadsheet automation tool trusted by over 300,000 professionals worldwide.

Sync data from your CRM, database, ads platforms, and more into Google Sheets in just a few clicks. Set it on a refresh schedule. And, use AI to write formulas and SQL, or build charts and pivots.

Julian Alvarado Content Marketing
Julian is a dynamic B2B marketer with 8+ years of experience creating full-funnel marketing journeys, leveraging an analytical background in biological sciences to examine customer needs.
Google icon
300,000+ users on Google Marketplace
Wait, there's more!
Connect any system to Google Sheets in just seconds.
Get Started Free

Trusted By Over 20,000 Companies