How to automate Instagram posts using Google Sheets

An Instagram bot template that automates posting to Instagram from a google sheet using a bot.

# Install this Instagram bot template

To install this Instagram Axiom click 'Install template'. If you are a new user you will be required to create an Axiom.ai account before you can edit the template.

# Set up a Google Sheet

  1. Create a new Google Sheet. You can do this in your Chrome browser by entering the shortcut 'sheet.new', presuming you already have an account.
  2. Name your sheet something like 'Instagram Posts’.
  3. Set up two tabs titled 'Post' and 'Posted’.
  4. Add data to the ‘Post’ tab on your sheet. Each Post should be added to a new row, in this format:

# Configure the 'Interact with a page's interface: Fill in post'

We have configured this step for you. We have provided this guide for you to learn more about bot building.

  1. Go to page, Enter URL - should already be populated with 'https://www.instagram.com/'.
  2. Click Element: Not now. This click is to close the pop-up that appaears just when running the the bot. The select step has been set. Use element text is select as well as optional click incase the pop-up does not appear. To select this pop-up we ran the bot with a large wait allowing us to use the web inspector to find the class.
  3. Click Element: Create - Select the 'Create' button in the menu.
  4. Upload a file: Insta image - File Input Field, use the selector tool to pick the image upload button. In 'File Path' click 'Insert Data' and choose 'google-sheet-data' and in the preview select the image path.
  5. Click Element: Ratio - select, the ratio button.
  6. Click Element: Select ratio - select, the ratio use with to use
  7. Click Element: Next - Select the 'next' button.
  8. Click Element: Next - Select the 'next' button again.
  9. Enter Text: Write a caption - Select text field, use the selector tool to pick the caption field. In 'text' click 'Insert Data' and choose 'google-sheet-data' and in the preview select the caption.
  10. Click Element: Share - Select the 'Share' button.

Stuck please do watch the video.

# Set up the 'Write Data to a Google Sheet' step

  1. Spreadsheet - In the field called 'Spreadsheet', you can search for the Google Sheet you created. Once found, click to select.
  2. Sheet name - Choose the tab you created for posted.
  3. DATA - Select the 'google-sheet-data'.
  4. Clear data before writing | Add to existing data - Set this option to 'Add to existing data'.

# Set up the 'Delete rows from a Google Sheet' step

  1. Spreadsheet - In the field called 'Spreadsheet', you can search for the Google Sheet you created. Once found, click to select.
  2. Sheet name - Choose the tab you created for post.
  3. First row - set to 1.
  4. Last row - set to 1.

# set up the 'Jump to another step' step

  1. Jump to step - set the step you want to jump to make the bot loop in this case step one.
  2. Maximum cycles - set the amount of loops the bot must perform.

# Test run

We always recommed doing a test run - Check the 'Click Element: Share (Enable to send)' step is disabled to stop the bot posting.

automate post to Instagram from a google sheet

# Ready to post

Click on the step called 'Click Element: Share', it will be greyed out. Click on the menu icon top right-hand corner of the step. Then click 'Enable widget'. When run, the bot will now automate your Instagrams.

# Troubleshoot

Try these measures if your bot is not working. We would recommend you watch the video to troubleshoot.

  • The bot will not post, have you enabaled the click step?
  • The bot does not enter the caption check the 'Enter Text' steps have you inserted the data?
  • The bot still does not enter the posts. You may need to re-select the text fields or buttons. The video shows you how.

# More Social Media posting templates