🔓 Unlock all 10,000+ workflows & prompts free Join Newsletter →
✅ Full access unlocked — explore all 10,000 AI workflow and prompt templates Browse Templates →
Home n8n Workflow
January 22, 2026

Apify to Google Sheets, TikTok ideas captured fast

Lisa Granqvist Partner Workflow Automation Expert

You find a great TikTok rental clip, paste the link somewhere “for later,” and then it disappears into a tab graveyard. Next week you’re back to doom-scrolling, trying to remember what worked and why.

This is the kind of mess real estate marketers run into constantly. A content curator feels it too, and honestly, a busy agent doing their own social research gets hit the hardest. With Apify Sheets automation, you capture the winners, keep the reason attached, and share it with your team without chasing anyone for updates.

This workflow uses Apify to scrape TikTok rental posts, has AI filter for “couples in their 20s,” then logs the best finds in Google Sheets and posts the same notes to Slack. You’ll see what it does, why it’s valuable, and what you need to run it reliably.

How This Automation Works

The full n8n workflow, from trigger to final output:

n8n Workflow Template: Apify to Google Sheets, TikTok ideas captured fast

The Problem: TikTok Research Turns Into Random Notes

TikTok is great at showing you what’s trending, and terrible at helping you reuse it. You’ll save a clip, send it to yourself, or drop it in a Slack thread, but none of that builds a repeatable research system. The biggest issue isn’t even the link. It’s losing the context: why it felt relevant, what the hook was, and which audience it would actually work for. A week later you’re staring at a URL with zero memory, and the team still needs “three ideas by Friday.”

It adds up fast. Here’s where it breaks down.

  • Good clips get “saved” in five different places, so you waste time re-finding the same style over and over.
  • Most teams never write down the why, which means the idea can’t be reused or adapted confidently.
  • Manual filtering for a specific persona (like couples in their 20s) turns into hours of subjective scrolling.
  • Sharing is inconsistent, so your Slack channel fills with links but no direction, and nobody acts on them.

The Solution: Scrape TikTok, Let AI Pick Winners, Log + Notify

This workflow starts when you manually run it in n8n, usually during a research block. n8n asks Apify to run a TikTok Scraper against a specific hashtag (賃貸, “rental”), then pulls back the video metadata in one dataset. Next, an AI agent reviews those results and selects the clips that match your target persona, in this case “couples in their 20s.” A second AI agent then generates a plain-English explanation of why each pick is a good recommendation, so the idea stays usable later. Finally, the workflow appends the URL plus the reason into Google Sheets and posts the same text to your Slack channel so the team sees it immediately.

The workflow begins with Apify scraping and returning candidate videos. Then AI filters and explains the recommendations. Google Sheets becomes your library, and Slack becomes the distribution point so the ideas actually get used.

What You Get: Automation vs. Results

Example: What This Looks Like

Say you do TikTok research twice a week and try to capture 15 solid rental clips each time. Manually, if it’s about 5 minutes per clip to open, judge fit, copy the link, write a note, then share it, that’s roughly 2.5 hours per session. With this workflow, you kick off the run in n8n (about 2 minutes), let Apify scrape, then AI filters and writes the reason while you do something else. You mostly spend your time scanning the Sheet and picking what to use, which is closer to 20 minutes.

What You’ll Need

  • n8n instance (try n8n Cloud free)
  • Self-hosting option if you prefer (Hostinger works well)
  • Apify to scrape TikTok via an actor.
  • Google Sheets to store URLs and reasons.
  • Slack to post recommendations to a channel.
  • OpenRouter API key (get it from your OpenRouter dashboard).

Skill level: Beginner. You’ll connect credentials, choose a Sheet and a Slack channel, then run a test execution.

Don’t want to set this up yourself? Talk to an automation expert (free 15-minute consultation).

How It Works

You launch the run when you’re ready. It’s a manual trigger, which is perfect for research blocks when you want “fresh picks now,” not a constant drip.

Apify scrapes TikTok for a specific hashtag. The workflow runs the clockworks/tiktok-scraper actor, pulls back a dataset of videos tagged 賃貸 (rental), and passes the results into the AI step.

AI filters, then writes the explanation. The first agent selects clips that match “couples in their 20s.” The second agent generates a recommendation reason and formats the output so it stays readable in a spreadsheet and in Slack.

Google Sheets gets the log, Slack gets the alert. Each recommendation is appended to your Sheet so you build a library over time, then posted to your chosen channel so the team sees it without hunting.

You can easily modify the hashtag and the target persona based on your needs. See the full implementation guide below for customization options.

Step-by-Step Implementation Guide

Step 1: Configure the Manual Trigger

This workflow starts manually, so you’ll trigger it on demand for testing or one-off runs.

  1. Add the Manual Launch Trigger node as the workflow trigger.
  2. No fields are required—leave the node parameters empty.
  3. Connect Manual Launch Trigger to Run Actor and Fetch Dataset.

Step 2: Connect Apify to Fetch TikTok Data

This step runs the Apify actor to scrape TikTok videos matching a rental hashtag.

  1. Add the Run Actor and Fetch Dataset node.
  2. Set Operation to Run actor and get dataset.
  3. Set Memory to 8192.
  4. Set Actor ID to your Apify actor (value shows as [YOUR_ID] in the template).
  5. Set Custom Body to the full JSON expression:
    ={ "excludePinnedPosts": false, "hashtags": [ "賃貸" ], "maxProfilesPerQuery": 1, "proxyCountryCode": "None", "resultsPerPage": 1, "scrapeRelatedVideos": false, "shouldDownloadAvatars": false, "shouldDownloadCovers": false, "shouldDownloadMusicCovers": false, "shouldDownloadSlideshowImages": false, "shouldDownloadSubtitles": false, "shouldDownloadVideos": false }
  6. Credential Required: Connect your Apify OAuth2 API credentials.
  7. Connect Run Actor and Fetch Dataset to AI Reasoning Agent.

⚠️ Common Pitfall: If the Apify actor ID is not valid or the dataset is empty, the AI steps will receive no webVideoUrl data to analyze.

Step 3: Set Up the AI Reasoning and Summary Agents

Two AI agents select a suitable property video and then generate a short reason for recommendation.

  1. Add the AI Reasoning Agent node and set Text to:
    =20代カップル向けの物件を動画内から選択して下さい 説明や前置きは省いて下さい URLのみを出力して下さい --- #URL {{ $json.webVideoUrl }}
  2. Ensure OpenRouter Chat Engine is connected as the language model for AI Reasoning Agent.
  3. Credential Required: Connect your OpenRouter credentials in OpenRouter Chat Engine (credentials are set on the language model node, not the agent).
  4. Add the AI Summary Agent node and set Text to:
    =URLの動画を見て、20代カップルにおすすめな理由を出力して下さい。 説明や、指示文などは入れないで下さい URLと説明で分けて下さい {{ $json.output }}
  5. Ensure OpenRouter Chat Engine 2 is connected as the language model for AI Summary Agent.
  6. Credential Required: Connect your OpenRouter credentials in OpenRouter Chat Engine 2 (credentials are set on the language model node, not the agent).
  7. Connect AI Reasoning AgentAI Summary Agent.

If the AI output format looks inconsistent, keep the prompts exactly as shown to ensure the summary includes both URL and reason.

Step 4: Configure Output Destinations (Google Sheets and Slack)

The summary is stored in Google Sheets and then posted to Slack.

  1. Add the Update Sheet Row node.
  2. Set Operation to appendOrUpdate.
  3. Select your spreadsheet in Document ID (template shows [YOUR_ID]).
  4. Select Sheet Name (template shows gid=0 / シート1).
  5. Leave the column mapping in Columns set to autoMapInputData so the output field is captured.
  6. Credential Required: Connect your Google Sheets credentials.
  7. Add the Post Slack Notification node and set Text to:
    =おすすめの物件情報です {{ $json.output }}
  8. Set Select to channel and choose your Channel ID (template shows [YOUR_ID]).
  9. Credential Required: Connect your Slack OAuth2 credentials.
  10. Connect AI Summary AgentUpdate Sheet RowPost Slack Notification.

⚠️ Common Pitfall: If the Google Sheet doesn’t have an output column, the append/update may fail or write blank values.

Step 5: Test and Activate Your Workflow

Run a manual test to confirm the TikTok scrape, AI analysis, sheet update, and Slack post all succeed.

  1. Click Execute Workflow and trigger Manual Launch Trigger.
  2. Verify Run Actor and Fetch Dataset returns TikTok video data with webVideoUrl.
  3. Confirm AI Reasoning Agent outputs a single URL and AI Summary Agent returns URL + explanation.
  4. Check the Google Sheet row was appended/updated by Update Sheet Row.
  5. Confirm a message was posted in Slack by Post Slack Notification.
  6. When satisfied, switch the workflow to Active for production use.
🔒

Unlock Full Step-by-Step Guide

Get the complete implementation guide + downloadable template

Common Gotchas

  • Apify credentials can expire or need specific permissions. If things break, check your Apify token in n8n Credentials first, then confirm you can access the clockworks/tiktok-scraper actor.
  • If you’re using Wait nodes or external rendering, processing times vary. Bump up the wait duration if downstream nodes fail on empty responses.
  • Default prompts in AI nodes are generic. Add your brand voice early or you’ll be editing outputs forever.

Frequently Asked Questions

How long does it take to set up this Apify Sheets automation automation?

About 30 minutes if your Apify, Google, and Slack accounts are ready.

Do I need coding skills to automate Apify Sheets automation?

No. You’ll connect credentials and edit a few fields like hashtag, Sheet, and channel.

Is n8n free to use for this Apify Sheets automation workflow?

Yes. n8n has a free self-hosted option and a free trial on n8n Cloud. Cloud plans start at $20/month for higher volume. You’ll also need to factor in OpenRouter (LLM) usage costs, which are usually small for short summaries.

Where can I host n8n to run this automation?

Two options: n8n Cloud (managed, easiest setup) or self-hosting on a VPS. For self-hosting, Hostinger VPS is affordable and handles n8n well. Self-hosting gives you unlimited executions but requires basic server management.

Can I customize this Apify Sheets automation workflow for a different hashtag and audience?

Yes, and it’s the point of using n8n. Change the hashtag in the Apify scraping node (the actor input body), then update the prompts in the two AI Agent nodes to match your persona. Common tweaks include switching from “20s couples” to “students,” focusing on a different city, or asking the AI to output separate fields like title, creator, and a “hook style” column for your Sheet.

Why is my Apify connection failing in this workflow?

Usually it’s an expired or incorrect Apify API token saved in n8n. Update the credential, then re-run a small test scrape to confirm the actor can execute. It can also be permissions on the actor you’re trying to use, or rate limits/credit limits in Apify if you crank up volume.

How many videos can this Apify Sheets automation automation handle?

A lot, as long as your Apify plan and your n8n execution limits support it.

Is this Apify Sheets automation automation better than using Zapier or Make?

Often, yes, because this isn’t just “send a link somewhere.” You’re scraping a dataset, then doing two rounds of AI reasoning, then writing to Sheets and notifying Slack, which is exactly where n8n’s branching and data handling feels calmer (and cheaper at scale if you self-host). Zapier or Make can still work if you keep it simple, but scraping + AI filtering tends to get clunky fast. One more thing: n8n makes it easier to keep the full text output consistent so your spreadsheet stays clean over time. If your team is split on tools, Talk to an automation expert and we’ll sanity-check the best route.

Once this is running, TikTok research stops being a “hope I remember this later” habit and turns into a shared library your team can actually build on. Set it up once, then just collect the good stuff.

Need Help Setting This Up?

Our automation experts can build and customize this workflow for your specific needs. Free 15-minute consultation—no commitment required.

Lisa Granqvist

Workflow Automation Expert

Expert in workflow automation and no-code tools.

×

Use template

Get instant access to this n8n workflow Json file

💬
Get a free quote today!
Get a free quote today!

Tell us what you need and we'll get back to you within one working day.

Get a free quote today!
Get a free quote today!

Tell us what you need and we'll get back to you within one working day.

Launch login modal Launch register modal