Copy tweets from a profile to Google Sheets

Twitter is a great platform for research and analysis. But manually copying and pasting tweets into a Google Sheet is time-consuming and prone to errors. This automation will help you quickly get tweets from any profile into a Google Sheet. You can use this data to track a competitor’s product launches, do analysis on their marketing strategies, or keep tabs on industry news.

Let’s set this up.

Step 1: Pin the playbook and integrate Google Sheets and Twitter

First, click the 'Pin it' button at the top of this page to save this automation. You will be redirected to download the browser extension when you run it for the first time. Bardeen will also prompt you to integrate Google Sheets.

Step 2: Run the playbook to copy tweets from a profile to Google Sheets

Run the playbook for a Twitter profile. It will scrape tweets from the profile and save them to a Google Sheets.

You can now navigate to a Twitter profile and run this automation from there. Launch Bardeen by clicking on the extension icon (or open with a shortcut Option + B on Mac or Alt + B on a Window machine) and click on the playbook card. Bardeen’s scraper tool will get information like the tweet content, timestamp, number of likes, retweets, and replies. You can also add more information by customize the scraper model.

Find more Google Sheets automations, or edit the playbook to suit your own workflow.

‍

‍