8 n8n Apify + Google Sheets automations

Every free, copy-paste n8n recipe that connects Apify and Google Sheets in one workflow. Each is a ready-to-run AI agent — import it, connect both accounts, and it runs 24/7. No code, no signup. See all Apify or Google Sheets recipes.

Browse 8 recipes →
Free recipe
Free
YouTuben8nClaude
YouTuben8nClaudeGoogle Sheets

Auto-Optimize YouTube Video Descriptions and Tags for SEO with AI

An n8n workflow that reads each new video's transcript, has Claude write an SEO-optimized description, timestamped chapters and keyword tags, and saves the package to Google Sheets for a quick paste into YouTube Studio — turning throwaway descriptions into a search-traffic engine.

n8nApifyClaude APIGoogle Sheets
Intermediate · 40 min setup
Free recipe
Free
TikTokn8nGoogle Sheets
TikTokn8nGoogle Sheets

Log TikTok Hashtag Performance to Google Sheets Every Day

An n8n workflow that tracks the hashtags you care about on TikTok, records daily view counts and top videos to Google Sheets, and builds a growth chart over time — so marketers can prove which hashtags actually move views instead of guessing.

n8nApifyGoogle Sheets
Intermediate · 45 min setup
Free recipe
Free
ShopifyTikTokn8n
ShopifyTikTokn8nClaude

TikTok Trend Product Radar: spot winning dropshipping products twice a week, automatically

An n8n workflow that scrapes trending TikTok product videos twice a week, has Claude score each product for saturation and audience fit, then logs everything to Google Sheets and pings your Telegram with the top 5.

n8nApifyClaude APIGoogle Sheets
Intermediate · 45 min setup · ✓ Tested
Free recipe
Free
n8nShopifyGoogle Sheets
n8nShopifyGoogle Sheets

Monitor Competitor Prices on Your Key Products and Get Alerted When Undercut

Losing a sale because a competitor quietly dropped their price is avoidable. This workflow scrapes competitor product pages for your key SKUs on a schedule and alerts you the moment you're undercut — with the gap and a suggested response.

n8nShopifyApifyGoogle Sheets
Advanced · 50 min setup
Free recipe
Free
n8nClaudeGoogle Sheets
n8nClaudeGoogle Sheets

Job-Post Lead Finder: companies hiring for a role are companies with that problem — catch them weekly

An n8n workflow that scrapes fresh job listings for roles that signal a need for your service (hiring a 'social media manager' = needs content help), has Claude extract the company, size hints, and pain signals, and delivers a scored lead list to Google Sheets every Monday.

n8nApifyClaude APIGoogle Sheets
Intermediate · 45 min setup
Free recipe
Free
YouTuben8nClaude
YouTuben8nClaudeGoogle Sheets

YouTube-to-Blog Converter: every new video becomes a full SEO article, automatically

An n8n workflow that watches a YouTube channel's RSS feed, pulls the transcript of each new video with an Apify actor, and has Claude turn it into a structured blog post — title, headings, FAQ section — saved to Google Sheets ready to paste into your CMS.

n8nApifyClaude APIGoogle Sheets
Intermediate · 45 min setup
Free recipe
Free
n8nClaudeGoogle Sheets
n8nClaudeGoogle Sheets

Product Review Summarizer: 500 competitor reviews distilled into what buyers actually want

An n8n workflow that scrapes the reviews of any Amazon or AliExpress product with an Apify actor, has Claude cluster them into top praises, top complaints, and unmet wishes, and writes a one-page product-improvement brief to Google Sheets — market research that used to take a weekend, done in minutes.

n8nApifyClaude APIGoogle Sheets
Intermediate · 40 min setup
Free recipe
Free
Google Mapsn8nClaude
Google Mapsn8nClaudeGoogle Sheets

Google Maps Lead Machine: 100 qualified local-business leads every week, with a personalized opening line

An n8n workflow that scrapes local businesses from Google Maps, filters out the ones without a website or with low ratings, has Claude write a personalized cold-email opener for each, and drops everything into a ready-to-send Google Sheet.

n8nApifyClaude APIGoogle Sheets
Intermediate · 40 min setup · ✓ Tested
Looking for something else? Browse all integrations or search every recipe. Some ingredient links are affiliate links — full disclosure.