Twitter to Google Sheets: Query from Twitter into Google Sheets using Sheet Director.
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.
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 all data from Twitter and store it into a Spreadsheet.
Setting up Twitter in Sheet Director
Choose App and Service:
Select Twitter from the list of applications.
Select service as Query.
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.
Configure Filter to filter the executed data as required.
Configure the destination settings to save the executed data.
Switch on Run automatically to execute services automatically in background.
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.