Short answer: the classic trick of auto-saving hashtag tweets to a Google Sheet with IFTTT no longer works, because X (Twitter) locked down its free API. Today your realistic options are native features for small jobs, manual copy or screenshot for a few tweets, and a paid API or third-party service for serious archiving. Here is what actually works now and how to choose.
Why the old method stopped working
For years you could connect Twitter to IFTTT or Zapier and pipe every tweet matching a hashtag into a spreadsheet automatically. In 2023 X ended free API access and most of those free automations broke. Any old tutorial promising a free auto-to-Sheets flow is out of date, so do not waste time on it.
Option 1: For a few tweets, save them manually
- Bookmarks: save tweets to your X Bookmarks for later.
- Copy the link: paste tweet URLs into a Google Sheet yourself, quick for a handful.
- Screenshot: for keeping the visual, especially if the tweet might be deleted.
Option 2: For ongoing archiving, use a paid API or service
If you genuinely need every tweet from a hashtag collected over time, you now need either a paid X API tier or a third-party social-listening/archiving tool that has paid access. These can export to CSV or Google Sheets, but they cost money because the underlying data access does.
Option 3: Export your own data
To archive your own tweets (not a public hashtag), request your X data export under Settings > Your account > Download an archive of your data. You get a full file of your own posts.
Which approach fits you?
| Need | Best option |
|---|---|
| A few tweets | Bookmarks or manual links in a Sheet |
| Ongoing hashtag archive | Paid API or archiving service |
| Your own tweets | X data export |
The non-obvious tip: capture before it disappears
Tweets get deleted, and links then break. If a tweet matters to you, screenshot it and paste the image alongside its URL in your Sheet. A link-only archive is only as permanent as the original post, which you do not control.
Frequently asked questions
Can I still save tweets to a Google Sheet automatically?
Not for free. X ended free API access in 2023, breaking the old IFTTT and Zapier automations. You now need a paid API or service for auto-archiving.
How do I save tweets from a hashtag?
For a few, use Bookmarks or paste tweet links into a Sheet. For ongoing collection, use a paid X API tier or a third-party archiving tool.
How do I download my own tweets?
Go to Settings > Your account > Download an archive of your data on X to get a full export of your own posts.
Why did my IFTTT Twitter automation stop working?
X restricted its free API in 2023, so most free Twitter automations on IFTTT and Zapier no longer function.
Comments
Post a Comment
If you have anything in mind, please let me know!