Google Sheets + Twitter Integration
Query from Twitter into Google Sheets
What is Sheet Director?
Sheet Director is a Google Workspace add-on that helps to manage and control bi-directional data flow between Google Sheets and several other applications like Google Calendar, Tasks, Contacts, Sheets, QuickBooks, FreshBooks, Zoho, Zendesk, Twitter, etc.
Installation:
It is available in the Google Workspace Marketplace. Please check the Installation instructions to install the add-on.
What is Twitter?
Twitter is a micro-blogging and social networking service on which users post and interact with messages known as "tweets". Registered users can post, like, and retweet tweets, but unregistered users can only read them.
Twitter to Google Sheets: Use Case
> Pull data from Twitter and store it into a Spreadsheet - Query
Sheet Director
Google Sheets
Setting up Twitter in Sheet Director
Choose App and Service:
Select Twitter from the list of applications.
Select service as Query.
Twitter Configuration:
Click on CONNECT TO TWITTER to connect with Twitter.
Authorize Sheet Director to access your account.
Mention your User Name.
Mention the Password.
Click on Authorize app to authorize with Sheet Director.
Select the required entity.
Select the fields that are required.
Filters
Configure Filter to filter the executed data as required.
Destination Settings:
Configure the destination settings to save the executed data.
Scheduler Settings:
Switch on Run automatically to execute services automatically in background.
Notification Settings:
Configure the Notification settings to setup the email templates and add attachments.
Click Execute to execute the services.
Click Save to save the services.
Click Back to exit.
Sample Output
