Grok Bot archives X bookmarks into Google Sheets and Drive nightly
A single prompt has Grok Bot export all X bookmarks, add AI tags, back up media to Drive, and update itself every night at 23:00.
I turned my X bookmarks into: - a searchable Google Sheet with AI tags - every image backed up to Drive - it updates itself every night at 23:00 Here's the prompt to set it up in Grok Bot @bot in 1 min (or copy this tweet) ===== Set up an X (Twitter) bookmarks archive for me. 1. Connect my X account (X plugin), Google Sheets and Google Drive. Ask me to connect any that are missing. 2. Export ALL my X bookmarks, including the ones in bookmark folders. 3. Create a Google Sheet called "X Bookmarks" with one row per bookmark, newest first, and these columns: Date (my local time), Author, Handle, Full text (also long posts and X Articles), Link, Tags, Folder, Media (Drive links), Original media URLs, Likes, Post ID. Freeze and bold the header, wrap the text column and turn on filters. 4. For each post, write 3 to 6 short lowercase topic tags so I can find it later. Keep the tags consistent across posts, and add a second sheet "Tags" with every tag and its count. 5. Download every photo (original size) and video or GIF thumbnail, upload them to a Google Drive folder "X Bookmarks – media", and link each file in the Media column of its row. 6. Then create a routine that runs every day at 23:00 my time: it finds bookmarks that aren't in the sheet yet, adds them at the top with tags and media saved to Drive, and tells me how many were added. If there's nothing new, it stays quiet.