How to Search Tweets from Specific Users Containing a Certain Word & Add to Google Sheets Using Pabbly Connect

Learn how to search tweets from specific users containing certain words and automatically add them to Google Sheets using Pabbly Connect in this step-by-step tutorial.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Twitter and Google Sheets Integration

To begin the process of searching tweets from specific users containing certain words, you need to access Pabbly Connect. Start by typing the URL Pabbly.com/connect in your browser. Once you reach the landing page, you will see options to sign in or sign up for free. If you are a new user, click on the ‘Sign Up’ button, which takes only a few minutes to complete.

After signing in, you will find yourself on the dashboard of Pabbly Connect. Here, you can click on the ‘Create Workflow’ button to initiate the integration process. Name your workflow something descriptive, like ‘Search Tweets from Specific Users Containing a Certain Word or Hashtag’. This name will help you identify the workflow later.

2. Setting Up the Twitter Trigger in Pabbly Connect

In this step, you will set up the trigger for your workflow using Pabbly Connect. Click on ‘Trigger Application’ and select Twitter as your trigger app. The event you want to choose is ‘New Tweet in List’. This event will trigger the workflow every time a new tweet is posted by any user in your specified Twitter list.

Once you select the trigger event, Pabbly Connect will check for new tweets every 10 minutes. Click on ‘Connect’ to link your Twitter account with Pabbly Connect. You will need to authorize the connection by signing into your Twitter account and granting access. After successful authorization, you will be prompted to enter the List ID of the Twitter list you want to monitor.

• Select the Twitter list you want to track.
• Click on ‘Save and Send Test Request’ to test the trigger.

After testing, you should see the last tweet from the specified list. This indicates that your Twitter trigger is set up correctly in Pabbly Connect.

3. Applying Filters to Search for Specific Tweets

Now that you have set up the Twitter trigger, the next step is to apply filters using Pabbly Connect. This filter will check if the tweet contains specific keywords or hashtags. In the workflow, go back to the Twitter step and select the ‘Full Text’ field to set your filter condition.

For example, if you want to track tweets containing the word ‘quote’, you can set the condition to ‘contains’ and specify the keyword. You can also add more conditions using the ‘or’ operator to include other keywords or hashtags. Click on ‘Save and Send Test Request’ to verify that the filter is functioning as expected.

• Set the filter to check for keywords like ‘quote’.
• Add additional keywords as needed.

Once the filter is set, you will receive a success response confirming that the tweet meets your filter criteria. This process ensures that only relevant tweets are captured in your Google Sheet through Pabbly Connect.

4. Adding Tweets to Google Sheets Using Pabbly Connect

With the filter in place, the next step is to add the filtered tweets to Google Sheets using Pabbly Connect. Select Google Sheets as your action application and choose the event ‘Add New Row’. Click on ‘Connect’ to link your Google Sheets account with Pabbly Connect.

After connecting, you will need to select the spreadsheet where you want to store the tweets. Choose the spreadsheet you previously created (e.g., ‘Tweets with Codes’) and the specific sheet within that spreadsheet. You will also need to map the data fields from Twitter to the corresponding columns in Google Sheets.

Map the username field to the Twitter screen name. Map the tweet description to the full text of the tweet. Map the creation date to the appropriate column in Google Sheets.

Once all fields are mapped, click on ‘Save and Send Test Request’. If successful, the tweet data will appear in your Google Sheet, indicating that the integration is complete and functioning correctly through Pabbly Connect.

5. Testing the Integration in Real-Time

Finally, to ensure that everything is working as intended, you should test the integration in real-time. Go to your Twitter account and post a new tweet that contains the specific keywords you set in the filter. After posting, wait for the polling period of 10 minutes for Pabbly Connect to check for new tweets.

After the waiting period, check your Google Sheet to see if the new tweet has been added. If the tweet contains the specified keywords, it should appear in your spreadsheet. This verifies that the integration between Twitter and Google Sheets using Pabbly Connect is successful and operational.

If you encounter any issues, revisit your workflow in Pabbly Connect to ensure that all steps are correctly configured and that the connections are properly authorized.

Conclusion

In this tutorial, you learned how to use Pabbly Connect to search tweets from specific users containing certain words and automatically add them to Google Sheets. By following these steps, you can streamline your social media tracking and data management efficiently.