Twitter to Google Sheets: Query from Twitter into Google Sheets using Sheet Director.
What is Sheet Director?
Sheet Director is a G Suite 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 G Suite Marketplace. Please check 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.
Select Filter if required.
Select the Field.
Select the operator required.
Mention the required value.
Click on "+" icon add more filters.
Mention the Max results 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.