OpenAI workflow'ları
630 sonuç — tümü kaynağa bağlı n8n referansı
W
Turn LinkedIn post reactions into AI content ideas with OpenAI and Google Sheets
Quick overview This workflow runs daily to fetch your recent LinkedIn post reactions via a RapidAPI LinkedIn endpoint, uses OpenAI to turn each reacted post into a structured original content idea, and appends or updates the results in a Google Sheets idea vault without duplicates. How it works Runs every day at 08:00 using a schedule trigger. Loads configurable settings like your LinkedIn username, reaction type filter, recency window, max posts to analyze, OpenAI model, and output language. Calls the linkedin-api8 RapidAPI endpoint to retrieve posts you recently reacted to and splits the response into individual reaction items. Filters reactions to keep only the selected reaction type (or all when blank) and posts newer than the configured number of days. Limits the number of reactions sent for analysis to control cost. Sends each source post (author, reaction, text, and URL) to OpenAI to generate a structured content idea (category, angle, hook, takeaway, format, and hashtags). Saves each idea to Google Sheets using an upsert that matches on Post URL to avoid duplicate rows. Setup Create a RapidAPI subscription for linkedin-api8 and add an HTTP Header Auth credential that sends
Analyze YouTube comments with OpenAI, Google Sheets, and Gmail
Quick overview This workflow monitors a Google Sheets list of YouTube video IDs, fetches video details and top comments from the YouTube Data API, analyzes the comments with OpenAI into structured sentiment and themes, emails an HTML report via Gmail, and writes the results back to Google Sheets. How it works Triggers every minute when a row in Google Sheets is added or updated. Reads the video ID and status from the row and continues only if the status is set to “Pending”. Calls the YouTube Data API to fetch the video’s metadata and the top comment threads for that video. Flattens the comment threads, calculates basic stats (comment count and average likes), and compiles a limited comment text block for analysis. If comments exist, sends the compiled comments and video title to OpenAI to generate a structured analysis (sentiment score, sentiment breakdown, themes, questions, feedback, insights, and summary). Builds an HTML email report from the structured results, sends it to the configured recipient with Gmail, and updates the Google Sheet row with the analysis fields; if no comments exist, marks the row as “No comments”. Setup Create or duplicate a Google Sheet with at least “Vi
Audit landing page CRO and log results with OpenAI and Data Tables
Quick overview This workflow collects a landing page URL, scrapes its HTML, and uses OpenAI to generate a structured conversion-rate-optimization (CRO) audit with scores and prioritized tips, then renders a styled report in the browser and logs each audit to an n8n Data Table. How it works Presents an n8n Form where the user submits a landing page URL. Fetches the landing page HTML via an HTTP request with retries, and routes to an error page if the URL can’t be retrieved. Sends the scraped HTML and URL to OpenAI to produce a CRO audit including an overall score, category scores, a written roast, and a ranked list of optimization tips. Uses a structured output parser with an OpenAI “fixer” model to validate and auto-correct the AI response into the required JSON schema. Builds a styled HTML report from the structured audit results. Logs the audit metadata (URL, score, verdict, summary, language, timestamp) to an n8n Data Table and displays the report back in the user’s browser. Setup Add an OpenAI API credential and select it for both the main OpenAI model and the output-fixer model. Create or select an n8n Data Table (for example, “CRO Audit Log”) and map the columns used for url,
Enrich company records with social media links using GPT-4o and Supabase
Quick overview This workflow is manually triggered to pull company names and websites from Supabase, crawl each site with an OpenAI-powered agent to extract social media profile URLs, and write the enriched results to a separate Supabase table. How it works Runs when you manually execute the workflow. Reads all rows from the Supabase companies_input table and keeps the name and website fields for processing. Uses an OpenAI (GPT-4o) agent to crawl the company website, following discovered links and extracting social media profile URLs. Forces the agent output into a structured JSON schema and maps the extracted links into a social_media array. Merges the original company name and website with the extracted social media data. Inserts the enriched record into the Supabase companies_output table. Setup Add a Supabase credential and set the correct project details for both reading from companies_input and writing to companies_output. Add an OpenAI API credential for the GPT-4o chat model used by the crawling agent. Ensure your input table has name and website fields or update the field selection and mapping to match your schema. Confirm the output table accepts the mapped fields (for ex
CAnswer WooCommerce order and DHL tracking questions with GPT-4 chat
Quick overview This workflow serves a demo web page with an n8n chat widget and runs an OpenAI-powered support agent that looks up WooCommerce orders and DHL tracking details by calling the same workflow as a tool. How it works Serves a demo HTML page via a webhook that embeds the n8n Chat widget configured to start a chat session. Triggers a new conversation when the chat widget connects and provides a customer email (mocked in this template) as session metadata. Uses an OpenAI (GPT-4) chat model with short-term memory to answer order-related questions and decide when to fetch live order data. Calls the same workflow as a tool with the customer email (and optional comma-separated order IDs) to retrieve matching WooCommerce orders. Looks up the WooCommerce customer by email, fetches their orders, and extracts shipment tracking metadata from each order. For orders with DHL tracking numbers, queries the DHL API for current shipment status, then merges tracking results back into the order data. Returns a JSON response containing the customer’s orders and any available DHL tracking details to the agent for use in the chat reply. Setup Add a WooCommerce API credential and update the sto
C
Summarize Zoom meetings and create follow-ups with OpenAI, ClickUp, and Outlook
Quick overview This workflow pulls the transcript and participant list from a recent Zoom meeting, uses OpenAI to generate formal meeting minutes, emails the summary via SMTP, and runs an AI agent that creates ClickUp tasks and (when details exist) schedules a follow-up meeting in Microsoft Outlook Calendar. How it works Starts when you manually run the workflow. Fetches your scheduled Zoom meetings and keeps only those that started within the last 24 hours. Requests the meeting recording files from Zoom, stops with an error if no transcript is available, then extracts the transcript download URL. Downloads the Zoom transcript file, extracts its text, and reformats it into clean, readable dialogue. Pulls the Zoom meeting participant list (including emails) and sends the transcript and participants to OpenAI to generate structured meeting minutes. Formats the minutes into an HTML email and sends the summary via SMTP to a participant email address. Uses an OpenAI-powered agent to extract action items and follow-up details from the same transcript, then creates tasks in ClickUp and creates a follow-up event in Microsoft Outlook Calendar when scheduling information is present. Setup Ad
WSend weekly blended ad performance reports with Meta Ads, Google Ads, GA4 and OpenAI
Quick overview This workflow runs every Monday at 8am, pulls last-7-days performance data from the Meta Ads API, Google Ads API, and Google Analytics 4, calculates blended KPIs, uses OpenAI to generate a client-friendly insight summary, and delivers an HTML report by Gmail while posting status update to Slack. How it works Runs every Monday at 8am on a schedule trigger. Fetches the last 7 days of spend and engagement metrics from the Meta Ads Insights endpoint. Fetches the last 7 days of campaign cost, clicks, and conversions from the Google Ads API using a streamed search query. Fetches the last 7 days of conversions and revenue by default channel group from the Google Analytics 4 Data API. Combines the three datasets and calculates blended totals for spend, conversions, revenue, and ROAS. Sends the blended metrics to OpenAI to generate a 3–4 sentence plain-language weekly performance summary. Builds a simple HTML report and sends it to the client via Gmail while posting a short “report sent” summary to a Slack channel. If the workflow execution fails, posts the error message to an ops Slack channel. Setup Add credentials and replace the placeholders for your Meta Ads token and ad
CWRoute insurance quote leads with OpenAI, Airtable, Sheets, Teams, Slack and Twilio
Quick overview This workflow receives insurance quote submissions via a webhook, normalizes and deduplicates them against Airtable and/or Google Sheets, uses OpenAI to score and classify the lead, then routes hot/warm leads to Microsoft Teams and/or Slack (plus Twilio SMS for hot leads) and logs the quote. How it works Receives an insurance quote request through a webhook endpoint. Applies configurable settings (log destination, notification channels, thresholds) and normalizes the incoming form payload into a standard quote format. Checks Airtable and/or Google Sheets for recent matching email/phone/hash entries to detect duplicate submissions. If the quote is new and has contact details, sends the quote data to OpenAI to generate a lead score, priority, underwriting flags, missing info, and recommended next steps. Routes the quote as hot, warm, or cold based on the score/priority and prepares formatted alert messages for Microsoft Teams and Slack. Posts hot/warm alerts to Microsoft Teams and/or Slack, and sends a Twilio SMS to an agent for hot leads. Creates a quote log record in Airtable and/or appends a row to Google Sheets, then returns a JSON response with logging and notific
Schedule weekly focus-time blocks with Google Calendar, OpenAI, and Slack
Quick overview This workflow runs every Sunday at 18:00 to scan your Google Calendar for next week, find free gaps of at least two hours within your working hours, auto-book them as “🧘 Focus Time” events, and then DM you a personalized deep-work plan in Slack using OpenAI. How it works Runs every Sunday at 18:00 on a schedule. Loads your working-hour preferences and fetches all events from your Google Calendar. Calculates weekday-only free gaps within your working hours and keeps only gaps that meet the minimum block length. If no qualifying gap exists, sends you a Slack DM warning that next week is too fragmented for a focus block. If gaps exist, limits the number of blocks for the week and creates “🧘 Focus Time (protected by n8n)” events in Google Calendar for each selected slot. Uses OpenAI to generate a short, personal Slack message that lists the protected blocks and suggests what kind of work fits each. Sends the generated deep-work plan to you as a Slack DM. Setup Add Google Calendar credentials, select the calendar to read from and the calendar to create “🧘 Focus Time” events in. Add Slack credentials and set your target Slack username in both the plan DM and warning mes
SRun a voice-enabled AI assistant on Telegram with OpenAI, Gmail and Notion
Quick overview This workflow turns a Telegram bot into a personal assistant that handles text and voice messages using OpenAI, can read Gmail and Google Calendar, looks up tasks and contacts in Notion, and can draft and send emails with a required approval step in Telegram. How it works Triggers when a new Telegram message is received by your bot. Detects whether the message is a voice note or text, and if it is voice, downloads it from Telegram and transcribes it with OpenAI. Sends the resulting user text to an OpenAI-powered agent that keeps a short conversation memory per chat. When needed, the agent fetches recent emails from Gmail, lists upcoming events from Google Calendar, and pulls tasks or contacts from Notion to answer the request. If the agent decides to send an email, it asks for approval in Telegram and only proceeds after you approve within the time limit. Sends the assistant’s final response back to the same Telegram chat. Setup Create a Telegram bot with @BotFather, add the Telegram credentials in n8n, and use the workflow’s Telegram trigger to connect the bot. Add an OpenAI API credential for both chat responses and voice transcription, and set your preferred model
Generate daily auto-service AI videos and post them with OpenAI, Perplexity, AtlasCloud, and Blotato
Quick overview This workflow runs daily (or manually) to research an auto-service topic with Perplexity, generate a caption and text-to-video prompt with OpenAI, render an AI video via AtlasCloud, then publish it to TikTok, YouTube, Instagram, and Facebook through Blotato while sending a Telegram preview. How it works Runs every morning on a schedule (or starts via a manual trigger). Loads your business settings (name, topic, language, video format, and CTA) from a central configuration. Uses Perplexity web research plus an OpenAI chat model to produce a structured caption, hashtags, and a cinematic text-to-video prompt. Sends the prompt to AtlasCloud to generate a short vertical video and waits before polling AtlasCloud for the render status. Repeats the wait-and-check loop until AtlasCloud reports the video render as completed. Prepares the final caption and video URL, then publishes the video to TikTok, YouTube, Instagram Reels, and Facebook Reels via Blotato and sends a Telegram message with the post preview and video link. Setup Add credentials for OpenAI, Perplexity, AtlasCloud (HTTP Header Auth), Blotato, and Telegram. Update the Configuration values (business name, topic, C
Create AI product video ad Shorts from Telegram photos with OpenAI and AtlasCloud
Quick overview This workflow takes a product photo sent via Telegram, uses OpenAI Vision to describe it and OpenAI to write a short-form video ad prompt, generates a vertical video via AtlasCloud, then (after two approvals in Telegram) publishes the Short to YouTube via Blotato. How it works Triggers when a user sends a product photo (optionally with a caption/campaign) to a Telegram bot. Downloads the image from Telegram and uses OpenAI Vision to extract an advertising-focused product description. Uses OpenAI to generate a single cinematic text-to-video prompt plus a YouTube Shorts title and description. Sends the proposed prompt to Telegram and waits for your approval before proceeding. If approved, requests video generation from AtlasCloud and polls the render status until the video is completed. Sends the generated video back to Telegram for preview and waits for a second approval to publish. If approved, publishes the video to YouTube as an unlisted Short via Blotato and notifies you in Telegram (otherwise it stops and sends a decline message). Setup Create and connect a Telegram bot credential, then start a chat with the bot so it can receive photos and send approval prompts.
Publish AI social posts from Telegram to LinkedIn, Instagram, Facebook and Threads with OpenAI and Blotato
Quick overview This workflow listens for a Telegram message or voice note, uses OpenAI to turn it into a cross-platform social caption and matching AI image, publishes the post via Blotato to LinkedIn, Instagram, Facebook, and Threads, then sends a confirmation back to Telegram. How it works Triggers when a new Telegram message is received by your bot. Routes the input as voice or text, downloading voice notes from Telegram and transcribing them with OpenAI. Sends the resulting text to an OpenAI chat model to generate a single ready-to-publish caption plus an image prompt. Generates an image with OpenAI (gpt-image-1) using the returned image prompt. Uploads the generated image to Blotato to get a hosted media URL. Publishes the caption and image to LinkedIn, Instagram, Facebook Pages, and Threads through Blotato. Sends a Telegram message confirming publication and includes the posted caption. Setup Create a Telegram bot in @BotFather, add the bot token as a Telegram credential in n8n, and activate the Telegram Trigger. Add an OpenAI API credential for audio transcription, caption generation, and image generation, and (optionally) adjust the model, language, image size, and quality
WSend weekly blended ad performance reports with Meta, Google Ads, GA4 and OpenAI
Quick overview This workflow runs every Monday at 8am to pull the last 7 days of performance from Meta Ads, Google Ads, and GA4, calculate blended KPIs, generate an OpenAI-powered narrative summary, email an HTML report via Gmail, and post an internal update (and errors) to Slack. How it works Runs every Monday at 8am on a scheduled trigger. Fetches the last 7 days of spend and engagement metrics from the Meta Ads Insights API, campaign cost and conversion metrics from the Google Ads API, and conversions and revenue by channel from the GA4 Reporting API. Combines the three datasets and calculates blended KPIs including total spend, total conversions, total revenue, and ROAS. Sends the computed metrics to an OpenAI chat model to generate a 3–4 sentence client-friendly performance summary with one risk and one recommendation. Builds a simple HTML report containing the KPIs and AI summary. Emails the HTML report to the client via Gmail and posts a brief confirmation with spend and ROAS to a Slack channel. If the workflow fails, posts an error alert message to an ops Slack channel. Setup Configure authentication for the HTTP requests to Meta Ads (access token), Google Ads (OAuth/access
Manage Google and Trustpilot reviews with OpenAI and Slack
Quick overview This workflow runs hourly to fetch new Google Business Profile and Trustpilot reviews, deduplicates them, uses OpenAI via a LangChain agent to draft sentiment-aware replies, escalates negative reviews in Slack, and routes positive replies to Slack for approval before posting the reply back to Trustpilot. How it works Runs every hour on a schedule. Fetches the latest reviews from the Google Business Profile API and the Trustpilot API and combines the results. Deduplicates reviews by tracking previously seen review IDs in workflow static data and stops if there are no new reviews. Processes each new review and uses OpenAI (via a LangChain agent) to generate structured JSON containing sentiment, a draft reply, and an optional suggested resolution. Sends negative reviews to a Slack channel for the owner along with the suggested resolution. Sends positive draft replies to Slack for one-tap approval (with a 24-hour timeout) and, if approved, publishes the reply to the Trustpilot API. Sends a Slack alert to the ops channel if the workflow errors. Setup Configure authentication and replace placeholders for the Google Business Profile reviews endpoint (account and location) i
Generate executive decision briefings from APIs with OpenAI and Google Sheets
Quick overview This workflow runs daily or via an on-demand webhook to pull financial metrics, operational KPIs, and market quotes via HTTP APIs, then uses OpenAI to detect anomalies and generate an executive briefing that is POSTed to a dashboard endpoint and logged to Google Sheets. How it works Runs on a daily schedule or receives a POST request via a webhook to start an executive briefing run with a configurable lookback period. Fetches financial metrics, operational KPIs, and market data in parallel from three HTTP API endpoints and continues even if one source fails. Merges and normalizes the three datasets into a single snapshot, marking missing sources as unavailable so downstream steps keep a consistent structure. Uses OpenAI to analyze the snapshot for anomalies, unusual trends, and data gaps, returning a severity-scored findings JSON. Uses OpenAI again to turn the anomaly findings and raw metrics into a structured executive briefing with a health score, risks, opportunities, and recommended actions. Formats a final JSON payload and delivers it by POSTing to your dashboard endpoint and appending a summary row to a Google Sheets tracker. If the run was triggered by the web
Route meeting action items to Slack using Gmail, OpenAI, and Google Sheets
Quick overview This workflow watches a Gmail label for new meeting transcript emails, extracts the transcript, uses OpenAI to generate a summary and action items, routes urgent items to the right Slack channel, and logs the meeting and action items to Google Sheets. How it works Triggers every minute when an unread email arrives in Gmail with the label Transcripts. Applies your configured Google Sheets and Slack settings, then extracts meeting metadata and transcript text from the email body. Reads the existing meeting log from Google Sheets and skips processing if the email matches a previously logged message ID or meeting hash. Sends the transcript to OpenAI to produce a JSON analysis including summary, decisions, risks, and structured action items. Parses and normalizes the action items, then routes the result as urgent, standard, or FYI based on priority and due date threshold. Posts a formatted message to the appropriate Slack channel when action items exist, otherwise marks the run as FYI. Appends the meeting record to the Meetings sheet and writes each extracted action item as a separate row in the ActionItems sheet. Setup Connect credentials for Gmail OAuth2, Google Sheets
Create TikTok carousel posts with Upload Post, Google Sheets, Gemini, GPT-4.1
Quick overview This workflow runs daily to pull TikTok post and profile analytics from Upload Post, updates a Google Sheets performance log, uses Google Gemini and OpenAI to generate a new carousel concept and caption, creates four images via fal.ai, publishes to TikTok, and updates a persistent “Agent Skill” sheet. How it works Runs on a daily schedule (or manually) and loads product, Upload Post, and Google Sheets configuration values. Reads the Google Sheets “Performance Log,” selects posts missing stats or posted recently, fetches TikTok post analytics from the Upload Post API, and writes updated metrics back to the sheet. Aggregates the refreshed history, fetches TikTok profile analytics from Upload Post, reads the “Agent Skill” sheet, and compiles a single context summary. Uses Google Gemini (via a structured JSON output) to generate a TikTok carousel plan including caption, strategy notes, four slide prompts, hashtags, and an engagement question. Sends the four prompts to fal.ai to generate four 9:16 PNG carousel images and collects their hosted image URLs. Uses OpenAI (GPT-4.1) to write a short TikTok photo-post description, publishes the carousel to TikTok via Upload Post
Extract invoice data from Google Drive images with GPT-4o and Postgres
Quick overview This workflow watches a Google Drive folder for new invoice images, extracts key invoice fields with OpenAI vision, checks for duplicates in Postgres, and then stores the invoice or moves the file into processed, duplicate, or failed folders. How it works Triggers every hour when a new file is created in a specific Google Drive folder. Downloads the new file from Google Drive and sends the image to OpenAI (GPT-4o) to extract invoice fields as JSON. Cleans and parses the AI response into structured invoice data, routing invalid or unparseable results to a failed path. Checks Postgres to see if an invoice with the same vendor name, invoice number, and total already exists. If the invoice is a duplicate, moves the source file in Google Drive to a duplicate folder. If the invoice is not a duplicate, inserts the invoice into the Postgres invoices table (status set to processed) and moves the source file to a processed folder. Setup Connect Google Drive OAuth2 credentials and set the incoming, processed, duplicate, and failed folder IDs to match your Drive structure. Add an OpenAI API credential and ensure the selected model (gpt-4o) is available for image analysis. Add Po
C
Post TikTok, YouTube Shorts and Instagram Reels with Airtable, OpenAI and Google
Quick Overview This workflow runs on a schedule, pulls the next publish-ready video from Airtable, uses OpenAI, Google Gemini, and CloudConvert to generate a transcript, title, description, tags, and hashtags, then uploads to YouTube Shorts, posts an Instagram Reel via Meta Graph API, and queues TikTok publishing via Google Sheets. How it works Runs on a schedule (or manually) and waits a random number of minutes to stagger posting. Searches Airtable for content marked Publish = true and Status = “In Publish Queue”, then selects a single record to process. Downloads the video, converts it to MP3 with CloudConvert, and transcribes the audio with OpenAI. Uses OpenAI and Google Gemini to extract a main keyword, generate a YouTube-optimized title, and create YouTube tags, hashtags, and a full YouTube description, then derives a shorter content-only caption for Instagram/TikTok. Uploads the video to tmpfiles.org to generate a direct file URL and updates the Airtable record with the generated metadata and set Status = “Published”. Uploads the video to YouTube with the generated title, description, and tags. Creates and publishes an Instagram Reel via the Meta (Facebook) Graph API after a
WScore LinkedIn job matches with OpenAI, Google Sheets, Slack, and Apify
Quick overview Runs fetch_cat/linkedin-jobs-scraper daily to collect recent LinkedIn jobs, scores each listing against your candidate profile with OpenAI, saves qualified matches to Google Sheets, and sends the five strongest results to Slack without redelivering previously processed job IDs. How it works Runs on a daily schedule (or via manual trigger) and ensures an n8n Data Table exists to track which LinkedIn job IDs have already been delivered. Runs the FetchCat LinkedIn Jobs Scraper (fetch_cat/linkedin-jobs-scraper) through Apify's API using your configured keywords and location, waits for the Actor run to finish, and downloads up to 10 structured job records from its dataset. Normalizes the scraped job records, caps the list to 10 items, and skips any jobs that already exist in the delivery ledger. Sends the remaining jobs to OpenAI in one structured request to score each job against your candidate profile and filters out results below the minimum score. Appends or updates qualified matches in Google Sheets (upserting by LinkedIn job ID) and formats a Slack message containing the five highest-scoring jobs. Posts the digest to your chosen Slack channel and records the deliver
SRun a Telegram voice and chat assistant with OpenAI, Gmail, Calendar, and Notion
Quick overview This workflow turns a Telegram bot into a personal assistant that understands text or voice notes (transcribed with OpenAI), can read Gmail and Google Calendar, look up Notion tasks and contacts, and can draft and send emails with an approval step in Telegram. How it works Triggers when a new Telegram message arrives. Loads assistant settings (name, OpenAI model, languages, memory window) and checks whether the message is a voice note or plain text. If it is a voice note, downloads the audio from Telegram and transcribes it with OpenAI; otherwise it uses the message text as the user input. Sends the user input to an OpenAI-powered agent that keeps short-term chat memory and decides whether to call Gmail, Google Calendar, or Notion tools to answer the request. If the agent decides to send an email via Gmail, it asks for explicit approval in Telegram before proceeding. Sends the agent’s final response back to the user in Telegram. Setup Create a Telegram bot with @BotFather, add your Telegram credentials in n8n, and start a chat with the bot so it can reply to you. Add an OpenAI API credential and set the desired chat model and transcription language in the Configurati
Create and approve AI social posts with OpenAI, Telegram and Blotato
Quick overview This workflow runs daily to generate an AI-written social post and DALL·E image with OpenAI, sends it to Telegram for approval, and—if approved—publishes it to LinkedIn, X, Instagram, Facebook, and Threads via Blotato while logging outcomes to Google Sheets. How it works Runs every 24 hours on a schedule trigger. Uses OpenAI to generate a single content topic (title, angle, and hook) based on your niche, audience, and language settings. Uses OpenAI to write one social post with a separate hashtag line and an image prompt in your specified tone and style. Uses OpenAI Images (DALL·E) to generate a matching image and extracts a shareable image URL. Sends the post text, hashtags, and image link to Telegram and waits for you to approve or skip within the configured time window. If approved, publishes the post with the image to LinkedIn, X, Instagram, Facebook, and Threads using Blotato and appends a “Published” log row to Google Sheets. If skipped or not approved, appends a “Skipped” log row to Google Sheets. Setup Add OpenAI API credentials and ensure the selected chat model and image model in the configuration match models available to your account. Add Telegram credent
WTrack and analyze TikTok videos with Apify, OpenAI, and Google Sheets
Quick overview This workflow runs daily (or manually) to fetch recent videos from a list of TikTok accounts via Apify, transcribes each video with OpenAI, generates content insights and translations, and then appends or updates one row per video in Google Sheets. How it works Runs on a daily schedule (or manually) and loads configuration values like the date window, video limit, output language, and Apify actor. Reads the TikTok usernames to monitor from the accounts tab in Google Sheets. Calls the Apify TikTok Scraper API to retrieve the latest videos for each configured account. Filters and normalizes the results to keep only videos published within the last N days and extracts metrics, captions, hashtags, and download URLs. Downloads each video file and transcribes it with OpenAI speech-to-text. Sends the transcription plus caption and hashtags to OpenAI to extract a hook, classify the content, infer the video format, and translate the transcription. Writes the combined video metadata, transcription, and AI insights to the insights tab in Google Sheets using an append-or-update operation. Setup Create a Google Sheets spreadsheet with an accounts sheet containing a username colum