Save TikTok Search Results to Google Sheets (n8n + RapidAPI)

Save TikTok Search Results to Google Sheets (n8n + RapidAPI)

Need to track TikTok content around specific keywords? This n8n workflow runs a RapidAPI TikTok Scraper search and immediately appends the API response to a Google Sheets spreadsheet—so you can log results and analyze them later.

What this workflow does

• Manual start in n8n: You trigger the workflow on demand using the Manual Trigger.
• Search TikTok via RapidAPI: An HTTP Request calls the RapidAPI TikTok Scraper endpoint using your configured search parameters (e.g., keyword, region, and pagination such as cursor/count).
• Write results to Google Sheets: The workflow appends returned response fields as a new row in Google Sheets, including status code/message, processed time, and the data payload.

Use cases

• Keyword monitoring: Quickly capture TikTok search results for specific terms and keep a running history in Google Sheets.
• Campaign tracking: Log results for brand/product keywords by region and revisit them later for comparison.
• Content research: Use saved responses to support reporting or manual review workflows across teams.
• Testing and prototyping: For SaaS operators or automation engineers, validate TikTok keyword queries and verify pagination behavior.

Technical details

• n8n nodes used: Sticky Note, Manual Trigger, HTTP Request, Google Sheets.
• RapidAPI integration: Configure X-RapidAPI-Key and X-RapidAPI-Host as HTTP Header Auth credentials in n8n.
• Google Sheets integration: Connect your Google Sheets OAuth2 credentials in n8n and set the target spreadsheet + sheet to append rows.
• Configurable query parameters: Update keywords, region, count, and cursor to control the TikTok search feed results.

Built for n8n automation workflows, this “save TikTok search results to Google Sheets” setup helps you turn TikTok Scraper API responses into structured, spreadsheet-ready logs.