Skip to content

Update Google Sheet row with TwitterID and Date after posting it on Twitter

Everytime you create a new tweet in your Google Sheets spreadsheet, Ibexa Connect will automatically post your current tweet from your Google sheet to your Twitter account. After that, Ibexa Connect will get the TwitterID and the date that the tweet was posted and update a specified Google Sheet row.

Final Output

twitter_.png

Step-by-step documentation

Based on the final output, there are three modules that are being used for this scenario.

twitter_1_.png

twitter_2_.png

  1. Add two more columns in your Twitter Google Sheet with the header names Date and TweetID.

  2. From your first exercise, add another module that updates your Google sheet with the date and the TwitterID after Ibexa Connect posts your tweet on your Twitter account.

    Click on the white field shown in the image below and then two options will appear, click on the Add another module button.

    twitter_3_.png

    Select the app and its corresponding module.

    Type Google Sheets and click on the app as shown below.

    sheets_.png

    Click on the corresponding module Update a row. This module will update your Tweet Google sheet with the date and TwitterID of your current Twitter post.

    update_a_row_.png

  3. Once you have your new module, a new tab will automatically pop up where you have to configure your Google Sheets settings as we did in exercise 1.

    google_sheets_.png

    First, click on the Add button and give Ibexa Connect access to your Twitter Google Sheet.

    connection_.png

    When you click on the Add button it pops up a new window and then click the Save button and then another window will open which is your Google Drive account.

    create_a_connection_.png

    On the newly popped up window click on the Allow button to give Ibexa Connect access to your Google Account.

    google_.png

    Once that is clicked, go back to your Ibexa Connect scenario, and then you have to choose the specific sheet that you want Ibexa Connect to choose the tweet from. In our case, it is the Twitter Google Sheet.

    From the File field, a drop-down will list all of your sheets available, and then choose the Twitter sheet.

    file.png

    After choosing the Twitter sheet, a few more fields will automatically appear below.

    Under the Worksheet field, choose the Tweets sheet because that is where the additional header titles Date and TwitterID are added.

    worksheet_.png

    Next, is the listed data inside the Tweet sheet, we have to correspond each specific field, on what data should be added to be updated.

    In this case, we want the Date and the TwitterID to be added in the Google Sheet once the current tweet was posted on Twitter.

    For the Date(date) field, drag the now variable to the field, that means that Ibexa Connect will get the date and time of the status that you have created right now.

    right_and_wrong_.png

    wrong_.png

    As you can see in the image above, we have chosen the color blue variable now, the blue color stands for the Twitter module, because we want the date of the Tweet to come from Twitter and not from the first Google sheet.

    Same goes with the TweetID field, as shown in the image below. We want the TweetID to come from Twitter and not from Google Sheets.

    correct_.png

    wrong_1_.png

    As for the RowID field, we have to get this from the Google Sheet module. Because the last module wants to know which tweet should be updated, so we have to set the row of that specific field.

    gsheets_.png

    As you can see, the color of the variable is green that is because we grabbed the data from the first module and we are getting the row of the tweet from the Google Sheet.

    After inputting all the variables, your tab should look like this:

    watch_a_worksheet_.png

    If your tab looks like this, then click the OK button.

  4. Run and execute your scenario.

    save_.png

    To test your scenario, add a new tweet to your Tweets sheet.

    twitter_sheet_.png

    Run your scenario once to see the flow of your scenario.

    run_once_.png

    After running the scenario, all of your modules should have a green letter as shown in the image below.

    google_sheets_twitter_scenario_.png

    That means that all of our modules have run properly and the data was processed properly.

    Check your Twitter account.

    twitter_test_.png

    See that the tweet from the Google sheet was processed and automatically transported to your Twitter account.

    And now, we check the Google sheet of the date and TweetID was added.

    google_sheet_twitter_data_.png

    We can see that the date and TweetID value has been added and therefore our Google Sheet has been updated.

  5. Setting up your scenario for daily use.

    Set up your scenario so that it runs every 15 mins. (Depending on your subscription plan). Please see below.

    subscription_.png

    As a free member your minimum number of minutes per cycle is 15 mins. (Based on what we are using in the example).

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

    scheduler_.png

    A new tab will open.

    If you click the dropdown button in the Run Scenario field, you have these options:

    schedule_setting_.png

    But in this case, you want to choose every 15 minutes, that is why you choose the At regular intervals option.

    setting_interval_.png

    As for the interval of the Schedule Setting, we can set it to 15 mins, since that is the minimum limit set by the rules of Ibexa Connect.

    Once we have that, click the OK button.

  6. The last thing we have to do is activate the scenario so we do not have to execute the scenario all the time, but it will run itself by the cycle that we have set which is 15 mins.

    Click on the Exit Editing button.

    exit_editing_.png

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

    After that, turn on your scenario to activate it.

    activate_.png

    Now, your scenario is done.

    Everytime you input something new to the Google Sheet row, Ibexa Connect will get the current row that is filled every 15 mins and post it to your Twitter account and updates your Google Sheet row with the Date and TweetID automatically.