Get a tweet on Twitter when a new tweet is created in a row in a Google Sheets spreadsheet

Description

Everytime you create a tweet on Google sheet, Make automatically posts the tweet from your Google sheet to your Twitter account.

Final Output

Get-a-tweet-on-Twitter-1.png

Step-by-Step Documentation

Based on the final output we can see that there are 2 modules that are being used for this scenario.

Get-a-tweet-on-Twitter-2.png
  1. Create a new Google Sheets spreadsheet with the file name Twitter and the sheet name Tweets. Create your first column by creating a column name, such as Tweet.

    Get-a-tweet-on-Twitter-3.png
  2. Go to your Make account and Login. Click Create a new scenario .

    Get-a-tweet-on-Twitter-4.png
  3. You may rename your own scenario as you wish. Click New scenario. Then type your preferred scenario name e.g. My Personal Scenario.

    Get-a-tweet-on-Twitter-5.png
    Get-a-tweet-on-Twitter-6.png
  4. Click on question mark ? and select the Google Sheets app > Watch a worksheet module.

    Get-a-tweet-on-Twitter-7.png

    Selecting the app:

    Get-a-tweet-on-Twitter-8.png

    Selecting the module:

    Get-a-tweet-on-Twitter-8_1.png
  5. Configure your module.

    Click Add to add a connection to your Google Drive.

    Get-a-tweet-on-Twitter-9.png
    Get-a-tweet-on-Twitter-10.png

    Click Save. A new window opens where you have to Allow Access to your Google Sheet.

    Get-a-tweet-on-Twitter-11.png

    In the File field, specify which file Make should grab the data from. In our case it is the Twitter file.

    Once you have chosen the filename, the Worksheet field will automatically appear, (in a worksheet, there can be many sheets listed) we will choose the Tweets sheet since that is the sheet we want to base our scenario off of

    As for the Maximum number of returned row, specify how many results your Twitter account should grab from the Google Sheet. In our example, we will use 1 and get the unprocessed rows one by one and not all at once from our Google sheet.

    But if we want to process all of the unprocessed rows all at once, then we should set the limit to a higher value (For example: 100 or higher)

    Get-a-tweet-on-Twitter-12.png

    After that, we just click the OK button.

  6. After clicking the OK button another tab will appear:

    Get-a-tweet-on-Twitter-13.png

    In this field, type in the number where you want Make to choose the data from (number of row in the Google Sheet.) Kindly note that the header of the column will omit the counting. That is why we put the number 1. (So it starts at the 2nd row.)

    And, then click the OK button.

  7. The next is to connect our 1st module to our Twitter account.

    We select the Add another module button.

    Get-a-tweet-on-Twitter-14.png

    We select another app; Twitter app.

    Get-a-tweet-on-Twitter-14_1.png

    Same as in the Google Sheets app, now we have to choose our specific module on what we want Twitter to do after Make monitors our Google sheet. In this case, we want Twitter to post a new tweet based on the current tweet that was inputted in the Google sheet tweet column.

    Get-a-tweet-on-Twitter-15.png

    Once we click on the module another tab will appear in the scenario.

    Get-a-tweet-on-Twitter-16.png

    Same with the Google Sheets connection, add your Twitter connection to the scenario. (Twitter account).

    Click the Add button.

    Click the Save button.

    Get-a-tweet-on-Twitter-17_1.png
    Get-a-tweet-on-Twitter-17.png

    In the new window click the Authorize App button, so that Make can access your Twitter account and link it to the Google Sheets module.

    Get-a-tweet-on-Twitter-18.png

    After authorizing your Twitter account, we now have to set the status.

    Once you click on the Status field, another tab will open.

    Get-a-tweet-on-Twitter-19.png

    In this field, specify which column we want to grab from the Google sheet which will then be redirected to the Twitter account.

    In this case, we will select the Tweet (tweet) value. 

    Drag and drop the Tweet (tweet) value to the Status field and click OK.

    Get-a-tweet-on-Twitter-20.png
  8. Once you have clicked on the OK button, you’re scenario is complete.

    Get-a-tweet-on-Twitter-20_1.png
  9. Save your scenario.

    Get-a-tweet-on-Twitter-21.png

    Once you click on the Run button, the scenario will run only once until you activate your scenario with the specified time cycle.

    Get-a-tweet-on-Twitter-22.png

    After executing, look at the scenario.

    Get-a-tweet-on-Twitter-23.png

    Only the Google Sheets module turned up green and the Twitter module did not turn green that is because our Google sheet is empty.

    Get-a-tweet-on-Twitter-24.png
  10. Inputting data into our Google sheet.

    Now, we have entered a Tweet under the Tweet column. Today is a great day.

    Get-a-tweet-on-Twitter-25.png

    Once we run the scenario again, notice how the Twitter module turns green.

    Get-a-tweet-on-Twitter-26.png

    And then a Twitter post was created automatically.

    Get-a-tweet-on-Twitter-27.png

    That means that there was data processed and the result was established.

  11. Setting up your scenario for daily use.

    Now, we want to run our scenario in a way that we want it to run every 15 mins. (depending on your subscription plan).

    Get-a-tweet-on-Twitter-28.png

    Click on the clock that is under the Google Sheets app.

    Get-a-tweet-on-Twitter-29.png

    A new tab will open. If you click the dropdown button in the Run Scenario field, you have these options.

    Get-a-tweet-on-Twitter-30.png

    But in this case we want to run it every 15 minutes, so choose the At regular intervals option.

    Get-a-tweet-on-Twitter-31.png

    As for the interval of the Schedule setting”, we can set it to 15 minutes, since that is the minimum limit for a free plan.

    Once we have that, click the OK** button.

  12. The last thing we have to do is activating the scenario so we do not have to execute the scenario all the time, but it will run itself by the interval we have set which is 15 mins. 

    Click on the Exit Editing button.

    Get-a-tweet-on-Twitter-32.png

    As you can notice, it will exit the editing mode. 

    After that, turn on your scenario to activate it.

    Get-a-tweet-on-Twitter-33.png

    Now, your scenario is done. Every time you input something new to the Google sheet under the Tweet column, Make will get the current data filled in every 15 mins and posts it to your Twitter account automatically.