n8n Workflow: Log Social Media & Google Search to Sheets

Log Instagram, TikTok, Twitter, and Google Search results into Google Sheets—on demand

This n8n workflow fetches the latest social posts for specified Instagram, TikTok, and Twitter accounts—plus relevant Google Search results—and appends everything into dedicated tabs in your Google Sheets spreadsheet. Run it manually whenever you need fresh visibility.

What this workflow does

• Manual execution: Starts when you trigger the workflow manually in n8n.
• Defines targets: Uses configured Instagram, TikTok, and Twitter usernames and a Google Search query.
• Instagram posts: Calls the RapidAPI Instagram Social API to retrieve up to 20 recent items from the last 7 days, then appends formatted post data to the Instagram Posts tab in Google Sheets.
• TikTok posts: Looks up the TikTok user via the RapidAPI TikTok API, extracts the user’s secUid, fetches up to 20 recent posts, and appends them to the TikTok Posts tab.
• Twitter posts: Retrieves the Twitter timeline via the RapidAPI Twitter API, keeps up to 20 tweets from the last 7 days, constructs tweet URLs, and appends them to the Twitter Posts tab.
• Google Search results: Runs a RapidAPI Google Search API request (limit 10) and appends title, description, and URL to the Google Search tab.

Use cases

• Monitor brand and competitor activity by logging social updates into a spreadsheet for reporting.
• Gather campaign references by pairing social posts with Google Search results on demand.
• Build lightweight reporting dashboards without complex databases—just Google Sheets.

Technical details

• Nodes/stack: set, code, sticky note, http request, Google Sheets, manual trigger
• External APIs via RapidAPI: Instagram Social API, TikTok API, Twitter API, Google Search API
• Auth: Add an HTTP Header Auth credential with X-RapidAPI-Key and ensure X-RapidAPI-Host matches each request.
• Google Sheets: Requires OAuth2 connection and existing tabs named for Instagram Posts, TikTok Posts, Twitter Posts, and Google Search.