A Twitter bot template that automates posting tweets from a google sheet using a bot.

Install this Twitter bot template

To install this Twitter 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 'Twitter Posts’.
3. Set up two tabs titled 'Post' and 'Posted’.
4. Add data to the ‘Post’ tab on your sheet. Each tweet should be added to a new row, in this format:

Set up the 'Read data from 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 sheet tab called 'Links'.
3. First cell - If the links are in column a set to 'A1'.
4. Last cell - Enter 'AB1' the bot will now only pass a single row of data.
5. You should now see a preview of the data.

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. Enter URL - should already be populated with 'https://twitter.com/compose/tweet'.
2. Enter Text: Tweet - Select text field, use the selector tool to pick the tweet input. In 'text' click 'Insert Data' and choose 'google-sheet-data' and in the preview select the tweet text.
3. Upload a file: Tweet 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.
4. Click Element: Tweet (Enable to send) - Select the 'Tweet' button when active i.e not grey.

Stuck 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.
3. DATA - Select the 'Interact 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 posts.
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 trial run - click run now and the Tweet will be entered but not posted. The 'Click Element: Tweet (Enable to send)' is disabled to stop the bot posting.

Ready to post

Click on the step called 'Click Element: Tweet', 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 Tweets.

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 Tweet, check the 'Enter Text' steps have you inserted the data?
• The bot still does not enter the Tweet. You may need to re-select the text fields or buttons. The video shows you how.

More Social Media posting templates

• Axiom template for posting on Instagram
• Axiom template for posting on Facebook