In this article, we’ll learn how to import Instagram data to Google Sheets. We can import Instagram data such as post likes, comments, stories of a user, a user’s followers and following lists, discover hashtags, and many more.
We’ll use an extension in Google Sheets–Amigo Data–to pull the data into Google Sheets. With it, you can easily find trending hashtags, find keywords related to a hashtag, and discover related profiles. Whether you are an influencer or a marketer, you’ll find it handy. If you’re neither, you’ll still find lots of uses, such as exporting and archiving all your posts in Google Sheets, getting the followers lists for a user, or their stories, and so on.
Read on to know how to import Instagram data to Google Sheets. Following are the steps to import Instagram data to Google Sheets.
How to import Instagram data to Google Sheets
Install the Amigo Data extension in Google Sheets
Install the Amigo Data Google Sheets add-on from the Google Workspace Marketplace.
Click here to install.
Alternatively, you can get it from Google Sheets.
- Open a new sheet
- Go to Extensions→Add-ons→Get add-ons
- Search for Amigo Data and install
Get the endpoint URL
We’ll be using a third-party Instagram on RapidAPI to import Instagram data to Google Sheets.
Sign up or log in to RapidAPI.
Once you’re logged in, go to the Instagram API Documentation page in RapidAPI.
Click on the Subscribe to Test button and subscribe to a plan that’s right for you. After subscribing to the API, we’ll be able to pull data from Instagram to Google Sheets.
On subscribing to a plan, an API key will be generated, which is used to authenticate API calls to RapidAPI.
Click Endpoints to go back to the API documentation. On the left is the list of the available data endpoints that we can pull from Instagram to Google Sheets.
Select any one, for example Hashtag Posts. This endpoint will return the top posts for a given hashtag along with the post metrics such as likes and comments.
There is only one required parameter for this endpoint, which is the hashtag parameter. Enter the keyword for which you want to fetch the information.
On the right of the screen under Code Snippets, we’ll find the URL along with the parameters and the headers.
Change the language to Shell→cURL. The query parameters are appended in the cURL so that we do not have to enter the parameters manually. Copy the URL and also note the headers. These will be used in the next step.
Import the data to Google Sheets
Open Google Sheets and launch Amigo Data from the sheet into which you want to fill the data. To connect to Amigo Data, click Extensions→Amigo Data→Connect.
You’ll be presented with a list of sources to connect to. Choose Custom API.
Paste the endpoint URL in the API URL field. Do not include the apostrophes. (Likewise for the headers.)
Then expand the Details tab and enter the headers.
You can specify the parameters here instead without going to RapidAPI to generate the URL. Enter the base endpoint URL which, for example Hashtag Posts, is: https://instagram47.p.rapidapi.com/hashtag_post
Then add the queries by clicking the “+QUERY” button and then entering the query names and the values. Name: hashtag, Value: marketing.
Click the PREVIEW button. Flatten and expand the nested datasets and delete the columns that are not required. Then click IMPORT.
The data will be imported into Google Sheets in a moment. Below is a snippet of the imported data.
Once the data have been imported into Google Sheets, they can be updated automatically at regular intervals–hourly, daily, weekly or on custom days–should you so wish, and get these data sent to your inbox. Click here to learn how to set a refresh schedule and set up alerts in Amigo Data.
Visit our blog to find out about the kinds of data that you can import to Google Sheets and how you can track stock and other financial data from Google Sheets.
Some related questions
How do I export Instagram followers to Google Sheets?
To export an Instagram user’s followers into Google Sheets, get the user ID of the account whose followers you can pull to Google Sheets. Then use the user ID as a parameter in the User Followers endpoint. And follow the steps in this tutorial to export the data to Google Sheets.
Note: You can only pull the follower list of those accounts that are not private. If an account is set to private, you’ll be able to extract only the follower count.
Can I pull Instagram Analytics data with this API?
No, unfortunately. This Instagram API only allows you to retrieve content-related data from Instagram and not analytics data. To export Instagram Analytics data to Google Sheets, you’ll have to use the official Instagram API. You can find the documentation here. Find the endpoint from the documentation and export the data to Google Sheets with Amigo.
Can I export a list of people I follow on Instagram?
Yes, you can export the list of people you’re following on Instagram. Find your user ID using the Get User ID endpoint. Then use the User Following endpoint to retrieve the list of people you follow on Instagram. Then use Amigo to export the list to Google Sheets.
Some recommended articles:
Import Mailchimp Data To Google Sheets