This is the automation flow ⚙️

Google Spreadsheet --> Google Calendar -->Tweet via 3rd Party Automation Service like Zapier --> Twitter

What it does 🦾

It puts your tweets from a Google spreadsheet into a calendar and from there it’s posted to Twitter via a Zapier integration.

Why this is 🆒

According to @garyvee those wanting to dominate the social media game, need to be putting out about 100 pieces of content per day😱 - ain't nobody got time for that! With this Google App Script you can batch process the workflow.

You need this to do it 🧰

1. Google Suite user account
2. Google Calendar
3. Google Spreadsheet
4. Twitter Account
5. 3rd Party Automation Account, we use Zapier but there are others

Steps 👟

1. Create a Google Calendar and name it “batch tweets”

2. Click the 3 dots and select “Einstellungen und Freigabe”
3. Scroll down and copy calendar ID, store in your preferred editor
4. Create a Google spreadsheet with 3 tabs. Name them: tweets, archive, calendarID
5. Add formula in column B: =QC(A1). Then apply formula to 20 fields
6. Go to tab 3 and paste calendar ID into A1 of your Google spreadsheet.

7. In your spreadsheet menu go to Tools and open Script editor

8. Copy and paste script for Google Apps script from Github. It’s two scripts: side panel + code

• Code Google Script
• Side Panel html

9. Go back to your Google spreadsheet, you should see a custom button named “Batch Tweets” in your navigation panel.

10. Click on it. This activates the script. A custom side panel opens.

11. Select what you need and press submit.

12. You're done when you see this:

13. Create a Zapier automation: Google Calendar to Twitter

14. Create Tweets in your Google spreadsheet

Congrats, you automated your twittering with Google Apps Script.

License

MIT