Skip to Content
Technical Articles
Author's profile photo Jonathan Francis

How to integrate Twitter & SAP Analytics Cloud: Step-by-step Walkthrough


This blog post is part of a series where we will be looking at integrating data from Twitter with SAP Analytics Cloud. In this installment, we have a full walkthrough of

  • How we are able to set up specific search criteria from Twitter,
  • How we are able to save this data,
  • How to use this data for stories built using SAP Analytics Cloud.

This blog post is also used as a guide for setting up SAP Analytics Cloud content being released for Q1 2022. Please follow the steps carefully to ensure the content works as expected.

What is the goal?

The target is for you to be able to set this up in your own environment by simply following the steps outlined in this blog. There is no coding involved and we have tried to keep this as simple as possible. All the additional tools we are using are free to use at the time of writing. 




In today’s blog post, we have broken it down into 4 Parts:

Part 1 – Tools & Accounts required

Part 2 – Creating the Twitter search

Part 3 – Setting up Google Drive

Part 4 – Connecting SAP Analytics Cloud to your data

These are simple steps that need to be done in sequence for SAP Analytics Cloud to ingest and use data from Twitter. Let’s get to it.



Part (1/4) – Tools & Accounts required

We will be using the 3rd Party Tools listed below that will require accounts to be created if you do not already have them.

  • Google
    • You will need a Google account for integration with IFTTT with access to Google Drive This account will also be used as the target of our Data Import from SAP Analytics Cloud via the Google Drive standard connection.
    • If you already have a valid Google Account, please proceed to the next step. If not, please find the link to create a Google Account below. Steps to create a Google account can be found here
  • Twitter
    • You will need a Twitter account for integration with IFTTT.
    • If you already have a valid Twitter Account, please proceed to the next step. If not, please find the link to create a Twitter account below. Steps to create a Twitter account can be found here
    • You will need an IFTTT(If This Then That) account to search for Twitter data and save data to Google Drive.
    • If you already have a valid IFTTT Account, please proceed to the next step. If not, please find the link to create a new IFTTT account here

Note: As mentioned earlier, these tools are all free to use at the time of writing.



Part (2/4) – Creating the Twitter search

In Part 2, we are going to get set up the Twitter search criteria we would like to track. We will do this in IFTTT.


  • Step 1: Creating an Applet in IFTTT
    • Go ahead and click “Create” on the IFTTT home page


Step 1 – IFTTT


  • Step 2: Adding a service
    • Select “Add” a new service


Step 2 – IFTTT


  • Step 3: Find the Twitter service
    • Search for the “Twitter” service and select it


Step 3 – IFTTT


  • Step 4: Select the Trigger
    • Search for “New tweet from search” and select it


Step 4 – IFTTT


  • Step 5: Connect your Twitter Account
    • You will be prompted to connect to your Twitter account. Please login to the Twitter account from Part 1
    • This is a one-time setup. Future triggers or applets will not require this step


Step 5 – IFTTT


  • Step 6: Search Criteria
    • Enter a search term or criteria of interest. This will be the Twitter search that continues to run and populate our Google Sheet.
    • In this example, we are looking for “@Sap4Good“. Go ahead and select “Create Trigger” once you are done.


Step 6 – IFTTT


  • Step 7: Connecting Google Drive
    • Next, we look to save the Twitter data to Google Drive with the “Add


Step 7 – IFTTT


  • Step 8: Find the Google Sheets service
    • Search for the “Google Sheets” service and select it


Step 8 – IFTTT


  • Step 9: Select the Action
    • Search for “Add row to spreadsheet” and select it


Step 9 – IFTTT


  • Step 10: Connect your Google Account
    • You will be prompted to connect to your Google account. Please login to the Google account from Part 1
    • This is a one-time setup. Future actions or applets will not require this step


Step 10 – IFTTT



  • Step 11: Spreadsheet format

This step will align with the format in our SAP Analytics Cloud standard content. Please ensure you follow this exactly if you are using this blog to set up your standard content story.

If you are following along in general, you can skip this step if you would like. Just keep in mind that the end result will slightly differ.

Update the “Spreadsheet Name

Old = New tweet from search

New = Tweets [Mentioning] [@SAP4Good]

“@SAP4Good” was the search criteria we used in our example. If your topic or handle is different, you can use that here. This is not critical as it doesn’t affect the search. It is to keep your documents easily sorted in Google Drive.

Update “Formatted Row

Old = {{CreatedAt}} ||| @{{UserName}} ||| {{Text}} ||| {{LinkToTweet}} ||| {{FirstLinkUrl}}

New = @{{UserName}} ||| {{Text}} ||| {{LinkToTweet}} ||| {{CreatedAt}}



Step 11 – IFTTT



  • Step 12: Confirm Trigger and Action
    • Confirm the steps in your applet by selecting “Continue


Step 12 – IFTTT


  • Step 13: Name your Applet
    • Review your title and select “Finish“. You can edit the title from the system generated title to something more descriptive like shown below
      • Tweets [Mentioning] [@SAP4Good]


Step 13 – IFTTT


  • Step 14: Review Applet
    • Your applet in IFTTT is now created and should be creating data in your Google Drive in no time
    • Depending on your search criteria and how often results are generated, the time taken for the first data entry may differ. This usually starts within the hour however if there is no data from your search criteria nothing will be created.


Step 14 – IFTTT


Part (3/4) – Setting up Google Drive

In Part 3, we are going to get set up the Google Sheets. We will do this in Google Drive.

  • Step 1: Setting Up Google Sheets
    • First, you will need to import a Google Sheet which we have already prepared for you.

a) Head to the shared Google Sheet link here:

Shared Google Sheet

b) You should be seeing a “View only” version of this document


Step 1 – Google Sheets


  • Step 2: Copying to your Google Drive
    • You will then need to make a copy of this document in your own Google Drive by going to “File” and “Make a copy


Step 2 – Google Sheets


  • Step 3: Saving to your Google Drive
    • Go ahead and name your Google Sheet and save this
    • The name is not critical since you can rename this at a later stage as well


Step 3 – Google Sheets


  • Step 4: Personal version of Google Sheet
    • You should now have a personal version of this Google Sheet to work with and edit
    • Previously greyed out options like “Insert” and “Format” should now be usable


Step 4 – Google Sheets


  • Step 5: Check for IFTTT Sheet
    • You should also have a new document in your Google Drive that IFTTT has created
    • This can be found in Google Drive under the “IFTTT” folder

If you still do not see this file, this might be related to your search criteria as mentioned earlier. You can either give it a little more time and confirm that tweets have been occuring since you created the applet or change the search criteria to something that occurs more often.


Step 5 – Google Sheets


  • Step 6: Sharing the Google Sheet
    • Next, we need to share the Google Sheet generated by IFTTT to link with our main document
    • Remember this step is done in the Google Sheet that was generated. The name should resemble “Tweets [Mentioning] [@SAP4Good]” if you followed our example


Step 6 – Google Sheets


  • Step 7: Sharing the Google Sheet
    • Select the “Change to anyone with the link


Step 7 – Google Sheets


  • Step 8: Copy the link
    • Copy this link to use in our main document
    • You can always come back and find this link at a later time as well following the same step as this link will not change


Step 8 – Google Sheets


  • Step 9: Linking with Google Sheet
    • Head back to your local copy of the shared Google Sheet. The name should resemble “Sac – Tweets [Mentioning][]” if you were following the example
    • Paste the link you just copied into Cell J3
    • You can also edit Cell C5 to match your search criteria. In our example, we will use @SAP4Good
      • This will help us in later steps to manage data in SAP Analytics Cloud if this is expanded and used multiple times


Step 9 – Google Sheets


  • Step 10: Confirm data linking
    • Confirm that your data is linked by going to the “SAC-Source” tab
    • You should be seeing data automatically being populated like we see below

If you are following along from the SAP Analytics Cloud content, do not edit anything on these sheets. These have already been formatted specifically for use with the Stories made available in content


Step 10 – Google Sheets


  • Step 11: Sharing for SAP Analytics Cloud
    • Finally, we share this Google Sheet as a data source for SAP Analytics Cloud
    • As with our previous sharing step, we go to “Share


Step 11 – Google Sheets


  • Step 12: Sharing for SAP Analytics Cloud
    • Select the “Change to anyone with the link


Step 12 – Google Sheets


  • Step 13: Copy link for SAP Analytics Cloud
    • And for your final step in Google Sheets, copy the link to be used later in SAP Analytics Cloud.


Step 13 – Google Sheets



Part (4/4) – Connecting SAP Analytics Cloud to the Data

In Part 4, we will be looking at how to connect SAP Analytics Cloud to Google Drive.

The following steps are catering to the SAP Analytics Cloud content use case. If you are following along without the content, you can jump to Step 4 by creating a new model and still set up your model.


  • Step 1: Find the Content Model
    • First, we need to find our Model which we installed from the SAP Analytics Cloud Content
    • This should be under Files / My Files / Public / SAP_Content / SAP_SM_Social_Media_Analysis


Step 1 – SAC


  • Step 2: Data Management
    • Once you have found this model, go to “Data Management


Step 2 – SAC


  • Step 3: Importing Data
    • Select Import data from a “Data Source


Step 3 – SAC


  • Step 4: Selecting Google Drive as a data source
    • Select “Data Source Type” as “Google” to make it easier to find Connection “Google Drive


Step 4 – SAC


  • Step 5: Linking to Google Sheet
    • Ensure the Google Drive File From is selecting “Google Sheet Url
    • Paste the URL copied from Step 27 in the previous section


Step 5 – SAC


  • Step 6: Selecting the Sheet
    • Ensure you have selected the sheet named “SAC-Source
    • Keep the “Use first row as column headers” selected


Step 6 – SAC


  • Step 7: Query run
    • Once the query has been run, you will see it available under the Draft Sources which you can select


Step 7 – SAC


  • Step 8: Confirm Columns
    • Columns should automatically map with the content without errors or issues
    • Select “Finish Mapping


Step 8 – SAC


  • Step 9: Viewing Story
    • If you head back to your story, you will now notice the newly loaded data is available for use
    • This should be under Files / My Files / Public / SAP_Content / SAP__SM_Twitter_Analysis


Step 9 – SAC


Success! You now have a Twitter feed linked to SAP Analytics Cloud. You can select the refresh times based on your own preference.


[Coming Soon] Demo

We will have a demo walkthrough of the steps above as well so check back soon.



Thank you for making it this far. We do hope this guide was helpful to you and serves as a starting point for your future development using SAP Analytics Cloud and integrating with Google Drive.


As we mentioned in the overview, this blog is part of a series. Check back soon for future posts.

Part 1: How to integrate Twitter & SAP Analytics Cloud: Step-by-step Walkthrough

[Coming Soon] Part 2


Thank you!

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Fakhar Ul Hasan
      Fakhar Ul Hasan

      Thanks. Wiser after reading your blog. That’s how it should be whenever one speaks up.

      Author's profile photo Jonathan Francis
      Jonathan Francis
      Blog Post Author

      Appreciate the kind words Fakhar Ul Hasan. Glad you could gain some insight from this post.

      Author's profile photo Kiran Bonam
      Kiran Bonam

      Hi Jonathan,

      This is really productive blog for SM Analysis to get some marketing insights. I tried and it worked well.

      Just couple questions...

      • Do we need to create multiple searches in IFTT for multiple twitter accounts or can include in single search ?
      • Any sort of approvals required if we want to go for multiple searches ?

      Appreciated for the nice blog!



      Author's profile photo Jonathan Francis
      Jonathan Francis
      Blog Post Author

      Hi Kiran Bonam,

      Great that it's working for you. One of the main goals was to show how easy this was. As for the questions:

      • Do we need to create multiple searches in IFTT for multiple twitter accounts or can include in single search ?
        • As much as I dislike this response, the answer is "it depends". Firstly, the IFTTT applet runs on Twitter advanced search rules which allow for multiple searches with commas to separate them so it is possible. However, you do have to think about the results that would be saved in your Google Sheet. It would be quite difficult to separate the data once we have created a multi-criteria search.
        • In my designs, I would recommend having multiple IFTTT applets and multiple Google Sheets connected to SAP Analytics Cloud as well. This is one of the reasons for the "Handle" column which would allow us to filter, delete and manage the data. This is something I use in my more advanced designs and I will have future blog posts about more complex search criteria and specific word counts in tweets.
      • Any sort of approvals required if we want to go for multiple searches ?
        • At the moment this is solely based on the IFTTT service which is integrated with Twitter so we are not calling any APIs on our own. With the free account, it currently lists that you have 5 free Applets that can be created for one account.

      If you do have more questions or comments feel free to list them out. I will take note of them when coming out with the next series. Thanks for reading!

      Author's profile photo ASUTOSH MAHARANA

      Dear Jonathan,

      Nice blog!!

      I think we can leverage SAP CPI as a middleware as well if the sole purpose of IFTTT to pull search results from Twitter as CPI too have inbuilt Twitter adapter to search terms from Twitter. It's also possible from cpi to generate excel/CSV file in a Google drive.



      Author's profile photo Jonathan Francis
      Jonathan Francis
      Blog Post Author


      Appreciate the feedback.

      You are absolutely right. We could connect Twitter APIs directly to SAP BW/4HANA or even use SAP HANA. We could also even call the Twitter API directly from Analytics Designer in SAP Analytics Cloud.

      What was shared here was a way to still access Twitter data for those users with access only to SAP Analytics Cloud.

      Thanks for pointing it out!

      Author's profile photo MAYA BOLETO

      Dear Jonathan,

      your blog is super !!!

      I have a question more related to sentiment analysis: do you know by chance the type of data that can be extracted as csv file. In your example I see date, time and related numbers. Do you have any suggestion?

      Thank you in advance,