Get the tools
Check out the required tools at https://sheetstweets.com/tools
Make sure to be logged in when you proceed to the next step.
Make a copy of the tool in Google Sheets
- Go to sheetstweets.com/get
- In Google Spreadsheet, go to “File” and click “Make a copy”
- Name your copy “Sheetstweets”
- Click the folder dropdown and click the “My drive” category
- Make a new folder by clicking the icon in the bottom right corner of the drop down.
- Name the new folder “Sheetstweets”.
Go to IFTTT and create the Recipes
Create the first recipe for adding your Medium recommends into Google Spreadsheet
- Click “My Recipes” in the top menu.
- Click “Create a Recipe”
- Click “This”
- Search for “Medium” in the search
- Select the Medium channel
- Click “Connect”
- Click “Authorize”
- Click “done”
- Click “Post recommended by you”
- Click “Create trigger”
- Click “That”
- Search for “Drive”
- Select “Google Drive”
- Click “allow” or “authorize”
- Click the option “Add row to spreadsheet”
- Fill in the following information
Spreadsheet name:Sheetstweets
Formatted row:{{PostTitle}}|||{{PostUrl}}|||{{RecommendedAt}}
Drive folder path:
Sheetstweets
- Click “Create action”
- Click “Create recipe”
Create the recipe for getting maker request from Google Spreadsheet and posting to Twitter
- Click “My Recipes” in the top menu.
- Click “Create a Recipe”
- Click “This”
- Search for “Maker” in the search
- Select the Maker channel
- Click “Connect”
- Click “Authorize”
- Click “done”
- Click “Receive a web request”
- Click “Create trigger”
- Click “That”
- Search for “Twitter”
- Select “Twitter”
- Click “allow” or “authorize”
- Click the option “Post a tweet”
- In “Tweet text” write this:
{{Value1}}
- Click “Create action”
- Click “Create recipe”
Create the recipe for getting maker request from Google Spreadsheet and adding a row in the sheet
- Click “My Recipes” in the top menu.
- Click “Create a Recipe”
- Click “This”
- Search for “Maker” in the search
- Select the Maker channel
- Click “Receive a web request”
- Click “Create trigger”
- Click “That”
- Search for “Drive”
- Select “Google Drive”
- Click “allow” or “authorize”
- Click the option “Add row to spreadsheet”
- Fill in the following information
Spreadsheet name:Sheetstweets
Formatted row:JUST_POSTED|||medium.com|||
Drive folder path:Sheetstweets
- Click “Create action”
- Click “Create recipe”
Get your maker key
- Go to https://ifttt.com/maker and look for “Your key is:”
- Copy your key
- Go to your spreadsheet
- Click the “Post tweet” tab
- Paste the key in the box to the right of “Key” in the green area.