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

1. Go to sheetstweets.com/get
2. In Google Spreadsheet, go to “File” and click “Make a copy”
3. Name your copy “Sheetstweets”
4. Click the folder dropdown and click the “My drive” category
5. Make a new folder by clicking the icon in the bottom right corner of the drop down.
6. Name the new folder “Sheetstweets”.

Go to IFTTT and create the Recipes

Create the first recipe for adding your Medium recommends into Google Spreadsheet

1. Click “My Recipes” in the top menu.
2. Click “Create a Recipe”
3. Click “This”
4. Search for “Medium” in the search
5. Select the Medium channel
6. Click “Connect”
7. Click “Authorize”
8. Click “done”
9. Click “Post recommended by you”
10. Click “Create trigger”
11. Click “That”
12. Search for “Drive”
13. Select “Google Drive”
14. Click “allow” or “authorize”
15. Click the option “Add row to spreadsheet”
16. Fill in the following information
    Spreadsheet name: Sheetstweets
    Formatted row: {{PostTitle}}|||{{PostUrl}}|||{{RecommendedAt}}
Drive folder path: Sheetstweets
17. Click “Create action”
18. Click “Create recipe”

Create the recipe for getting maker request from Google Spreadsheet and posting to Twitter

1. Click “My Recipes” in the top menu.
2. Click “Create a Recipe”
3. Click “This”
4. Search for “Maker” in the search
5. Select the Maker channel
6. Click “Connect”
7. Click “Authorize”
8. Click “done”
9. Click “Receive a web request”
10. Click “Create trigger”
11. Click “That”
12. Search for “Twitter”
13. Select “Twitter”
14. Click “allow” or “authorize”
15. Click the option “Post a tweet”
16. In “Tweet text” write this: {{Value1}}
17. Click “Create action”
18. Click “Create recipe”

Create the recipe for getting maker request from Google Spreadsheet and adding a row in the sheet

1. Click “My Recipes” in the top menu.
2. Click “Create a Recipe”
3. Click “This”
4. Search for “Maker” in the search
5. Select the Maker channel
6. Click “Receive a web request”
7. Click “Create trigger”
8. Click “That”
9. Search for “Drive”
10. Select “Google Drive”
11. Click “allow” or “authorize”
12. Click the option “Add row to spreadsheet”
13. Fill in the following information
    Spreadsheet name: Sheetstweets
    Formatted row: JUST_POSTED|||medium.com|||
    Drive folder path: Sheetstweets
14. Click “Create action”
15. Click “Create recipe”

Get your maker key

1. Go to https://ifttt.com/maker and look for “Your key is:”
2. Copy your key
3. Go to your spreadsheet
4. Click the “Post tweet” tab
5. Paste the key in the box to the right of “Key” in the green area.

 

Made with ♥ by Kim Døfler