Get a tweet on Twitter when a new tweet is created in a row in a Google Sheets spreadsheet¶
Everytime you create a tweet on Google sheet, Ibexa Connect automatically posts the tweet from your Google sheet to your Twitter account.
Based on the final output we can see that there are 2 modules that are being used for this scenario.
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.
Go to your Ibexa Connect account and Login. Click **Create a new scenario **.
You may rename your own scenario as you wish. Click New scenario. Then type your preferred scenario name e.g. My Personal Scenario.
Click on question mark ? and select the Google Sheets app > Watch a worksheet module.
Selecting the app:
Selecting the module:
Configure your module.
Click Add to add a connection to your Google Drive.
Click Save. A new window opens where you have to Allow Access to your Google Sheet.
In the File field, specify which file Ibexa Connect 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)
After that, we just click the OK button.
After clicking the OK button another tab will appear:
In this field, type in the number where you want Ibexa Connect 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.
The next is to connect our 1st module to our Twitter account.
We select the Add another module button.
We select another app; Twitter app.
Same as in the Google Sheets app, now we have to choose our specific module on what we want Twitter to do after Ibexa Connect 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.
Once we click on the module another tab will appear in the scenario.
Same with the Google Sheets connection, add your Twitter connection to the scenario. (Twitter account).
Click the Add button.
Click the Save button.
In the new window click the Authorize App button, so that Ibexa Connect can access your Twitter account and link it to the Google Sheets module.
After authorizing your Twitter account, we now have to set the status.
Once you click on the Status field, another tab will open.
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.
Once you have clicked on the OK button, you’re scenario is complete.
Save your scenario.
Once you click on the Run button, the scenario will run only once until you activate your scenario with the specified time cycle.
After executing, look at the scenario.
Only the Google Sheets module turned up green and the Twitter module did not turn green that is because our Google sheet is empty.
Inputting data into our Google sheet.
Now, we have entered a Tweet under the Tweet column. Today is a great day.
Once we run the scenario again, notice how the Twitter module turns green.
And then a Twitter post was created automatically.
That means that there was data processed and the result was established.
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).
Click on the clock that is under the Google Sheets app.
A new tab will open. If you click the dropdown button in the Run Scenario field, you have these options.
But in this case we want to run it every 15 minutes, so choose the At regular intervals option.
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.
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.
As you can notice, it will exit the editing mode.
After that, turn on your scenario to activate it.
Now, your scenario is done. Every time you input something new to the Google sheet under the Tweet column, Ibexa Connect will get the current data filled in every 15 mins and posts it to your Twitter account automatically.