A Step-by-Step Guide to Automating Posts Scheduling on Instagram from Google Sheets
Tags: zapier, integromat, airtable
Published: 2023-02-27 11:32:21

Instagram is a popular social media platform that requires consistent posting to keep your audience engaged. However, manually scheduling posts can be time-consuming and inefficient. Luckily, with the help of automation tools like Integromat, you can easily automate your Instagram posts scheduling using Google Sheets.

In this step-by-step guide, we'll show you how to set up a simple automation workflow that connects your Google Sheets and Instagram accounts using Integromat. By following these instructions, you can schedule Instagram posts in advance, saving time and effort, and ensuring a consistent online presence. With Integromat's powerful automation features, you'll be able to streamline your social media marketing strategy and focus on creating engaging content for your audience.

## Packages Needed
- Google Sheets
- Integromat (Make.com)
- An Instagram for Business account

## Guide
1. Setup your spreadsheet i.e create your column headers, and give your sheet a title. Our title would be “Instagram Prescheduled Content”. For this tutorial, our headers would be:

- Name: Unique Identifier for a particular post. 
- Photo URL: URL to the picture we intend to upl
oad
- Caption: Content of our Instagram post.
- Length: Max of 2,200 characters 
- Hashtag Content: 
- Status: Trigger. Takes on two values - Ready (to indicate next to get posted), Posted (to indicate posted record)

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/6m30n3fg710e171ubisl.png)
2. Head over to Integromat. On Integromat, create a new scenario. 

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/0ho1apczis5svx31833a.png)
3. Search for Google Sheets and Import it. Pick “Search Rows” as your trigger. 
4. Connect the imported app to your Google Account (if not previously connected). 
- To connect the app, tap on the “Add” icon .
- Fill in your preferred title for the connection. 
- Select which gmail account the spreadsheet is affiliated with.

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/j9dj214f7yeh8ob6mu92.png)
5. Search for the spreadsheet in question. For Us, that'd be ”Instagram Prescheduled Content”.  
6. Pick ‘Yes” to ‘Table Contains Headers’.
7. For the Filter box, pick which column you'd like to use to trigger the posts scheduling. For us, that'd be “Status” >> Equal to “Ready”.
8. In the “Max No of Returned Rows” secttion, indicate 1. Later, we'll adjust this figure. But for now, fill in 1 i.e the first row after header.
9. Tap on “OK”.

## Linking to Instagram.
1. Tap on the + icon beside the Google Sheets module.
2. Tap on the “Instagram for Business” module. Regular Instagram disallows API requests.
3. Tap on “Create a Photo Post”. If you'd rather create a video post, tap on that instead - ensure you've made the relevant modification in your spreadsheet.
4. Select the Instagram Page in the box provided.We’re assuming youve connectedd your account already.
5. Select the Photo URL from the interface provided. This would be the column it's stored under.
Select the caption the same way i.e the column under which it's stored
Updating Row Back in Google Sheets