Video sales letter scripts from Airtable

Video sales letter scripts from Airtable

An n8n workflow. Call its webhook with a record from your Airtable base, and it researches a product, proposes ad angles,
writes a video sales letter script for the angle you pick and rewrites it from your notes. A weekly job also logs your
active Facebook video ads, and a second webhook transcribes the video of a logged ad.

What is inside

• workflow.json: the workflow as n8n exports it, 54 nodes in three groups. It holds no credential, none of its author's
  Airtable ids and no stored run data. Its groups carry the labels Weekly Ad Schedule, Best Ad Video Transcript and
  Scripting/Idea Generation/Feedback System.
• README.md: these notes.
• Not included: the Airtable base. Build it from the table list below.

One repair: the original copy of the file had lost three backslashes. Mindket put them back in Code1 (the pattern that finds
the video address, and its & clean-up) and in the line join of Generate Angles.

Before you start

• An n8n instance with an address Airtable can reach: n8n Cloud, or your own server on the internet.
• An Airtable base with the three tables below, and a personal access token that can read and write it.
• A Perplexity API key.
• A Gemini API key from Google AI Studio.
• An OpenAI API key.
• For the weekly job: a Facebook Marketing API access token that can read ads.
• For transcripts: a Scrapfly API key.

The Airtable base

The nodes read and write these fields. Names are as the file writes them, emoji included.

| Table | Fields the workflow uses |
|---|---|
| Product | Product Name, Product Notes, Product Details, Status, 2️⃣ Generate Angles, Winning Ad Script, Angle Headline, and a link to Scripting |
| Scripting | AngleHeadline, ConceptSummary, VSLStructure, VideoSuggestion, EmotionalTriggers, CognitiveBiasesLeveraged, Direct Response Techniques, Script, Status, 5️⃣ Generate Script, About Product, a link to Product, and the length and feedback fields |
| Ads Performance | Ad Name, Ad ID, Video ID, Campaign Name, AdSet Name, Active Status, Spend, Impressions, Clicks, CPC, CPM, Conversions, Conversion Value, Best Ads?, Video Script |

Status on Product takes Idle, Generating Product Details, Generating Angles, Product Details Generated and Angles Generated.
On Scripting it takes Idle, Generating Script, Revision in progress, Script Generated and Script Revised.

In the file's schema, Winning Ad Script and Angle Headline on Product and About Product on Scripting are read-only, so
build them as lookups into the linked tables.

Set it up

1. In n8n, create a workflow, open its menu and choose Import from File. Pick workflow.json.
2. Add an Airtable credential with your personal access token. In every Airtable node, put your base in YOUR_BASE_ID, and the
   table in YOUR_PRODUCT_TABLE_ID, YOUR_SCRIPTING_TABLE_ID or YOUR_ADS_TABLE_ID, then select the credential.
3. Add an HTTP Header Auth credential: header name Authorization, value Bearer and your Perplexity key. Select it in
   Product Overview & Customer Research.
4. Add a Google Gemini (PaLM) API credential and select it in the three Gemini chat models. Add an OpenAI credential and
   select it in OpenAI Chat Model1 and OpenAI.
5. Add a Facebook Graph API credential with your token and select it in Get FB Ad Accounts, Get Ad Campaigns,
   Get FB Ad Sets, Get FB Ad Contents and Facebook Graph API10.
6. Open HTTP Request1 and replace YOUR_SCRAPFLY_KEY with your Scrapfly key.
7. Save, then press Publish at the top of the canvas (or Shift+P). Open Webhook and Webhook1, copy their production
   addresses and use them in Airtable.

Call it

Both webhooks use GET. A button field with an Open URL formula, or an automation with a script step, can make the call.

| Address | Query | What happens |
|---|---|---|
| ai-vsl | action=generateProjectDetails&recordId=<Product record> | Perplexity profiles the product and its buyers. Product Details is filled |
| ai-vsl | action=generateAngles&recordId=<Product record> | Gemini adds five to eight rows to Scripting |
| ai-vsl | action=generateScript&recordId=<Scripting record> | Gemini fills Script |
| ai-vsl | action=feedbackIteration&recordId=<Scripting record> | Gemini rewrites Script from the feedback field |
| ad-scraping | recordId=<Ads Performance record> | The ad's video is fetched and transcribed into Video Script |

The weekly job starts from Schedule Trigger2, so it needs no call.

How the weekly job and the transcripts work

The job lists your ad accounts, then their campaigns and ad sets, and keeps only those whose status is ACTIVE. For each ad set
it reads the ads with their results to date, keeps the active ones that have results and a video, and creates one Ads
Performance row per ad. The transcript flow reads that row and asks the Graph API for the video's page. Scrapfly loads that page in a
browser, the flow looks through the page's JSON for the video address, and OpenAI transcribes the downloaded file.

Change it

• Angles: the instructions sit in Generate Angles, and the count of five to eight is in its prompt.
• Scripts and rewrites: the instructions sit in Basic LLM Chain1 and Basic LLM Chain2.
• Research: the request text sent to Perplexity is in Edit Fields2.
• Weekly job: the interval is in Schedule Trigger2, and the ad fields it reads are in the fields query of
  Get FB Ad Contents.

Good to know

• Both webhooks are open. Anyone who learns an address can start runs that spend your keys, so add authentication to the
  webhook nodes or keep the addresses private.
• A rewrite replaces Script. Copy the old text first if you want to keep it.
• The script prompts read the fields Time and Feedback, but the file's own Scripting schema calls them
  3️⃣ Select Script Length and 4️⃣ Feedback. Make the field names and the expressions agree.
• Update Product Details clears 2️⃣ Generate Angles and leaves 1️⃣ Generate Product Details as it was.
• Airtable9 creates a new row for each active video ad every week and never updates an older one.
• Edit Fields6 takes conversions from actions[4] and conversion value from action_values[8]. Those positions fit one
  account's data, so check them against yours.
• Wait holds 30 with no unit, and n8n's default unit is seconds, so it pauses 30 seconds. Set minutes there if you
  meant them.
• The three Gemini nodes name an experimental model, models/gemini-2.5-pro-exp-03-25. If it is gone, pick a current one.
• The transcript flow depends on how Facebook builds its video page, so it can stop working when that changes. Check
  Facebook's and Scrapfly's terms for your use.
• Product notes and scripts go to Perplexity, Google and OpenAI. Ad videos go to Scrapfly and OpenAI. Ad results go to Airtable.