A Facebook template that automates posting to facebook from a google sheet using a bot.

Install this Facebook bot template

To install this 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 'Facebook 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:

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 'Post'.
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' step

1. Enter URL - Add the url of a Group or feed you would liek to post on
2. Click Element: What's on your mind?, use the selector tool to pick the post input.
3. Enter Text - In 'text' click 'Insert Data' and choose 'google-sheet-data' and in the preview select the post text.
4. Upload a file - 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: Post on Facebook - Select the 'Post' button when active i.e not grey.

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 'goggle-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 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 Post will be entered but not posted. The 'Click Element: Post on Facebook' is disabled to stop the bot posting.

Ready to post

Click on the step called 'Click Element:Post on Facebook', 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 Facebook posts.

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 message, check the 'Enter Text' steps have you inserted the data?
• The bot still does not enter the Post. 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 tweeting on Twitter