The Full Workflow For X Auto Post Creation And Posting

This is the first step, push the button and sign in:

Database Template Outline

Okay, now for explaining all of the tabs

External Content Sources:

• Source Name: The name of the trusted blog

• Source Type: What type of publication it is

• URL: The URL where the new articles are updated

• Notes: What the publication is all about

• Status: Active

Extracted Content - Don’t touch anything it will all be auto generated

My content:

• Source: The type of source it is (e.g. newsletter, youtube video, whatever)

• Content: The actual content of that content (I.e. full newsletter text, website page text, video transcript)

Links:

• Name: Link name (affiliate, landing page, lead magnet)

• Link: The actual URL of the link

• Purpose: The reason and description for that link (e.g. a description of your website home page such as “creator-tested AI workflows and systems to scale faster, save time, and start monetizing weekly.”)

X Post Generation Automation

We’ll go step by step through this and I’ll tell you what to change:

delete_extracted _content:

• google sheets account: Log into your google drive account where your Database template is located.

• Spreadsheet ID: Find your Database template

• Worksheet ID: Choose Extracted Content

• Start Index: 1

• End Index: 15

get_values_in_range:

• google sheets account: Log into your google drive account where your Database template is located.

• Spreadsheet ID: Find your Database template

• Worksheet ID: Choose External Content Sources

add_multiple_rows:

• google sheets account: Log into your google drive account where your Database template is located.

• Spreadsheet ID: Find your Database template

• Worksheet ID: Choose Extracted Content

• Row values

  • {{steps.limiter_step.$return_value.map(r => [r.sourceName, r.sourceURL, r.title, r.contentSnippet, r.fullContent, new Date().toISOString().split('T')[0], "AI, Automation, Content Creation"])}}

extracted_content:

• POST: https://openrouter.ai/api/v1/chat/completions

• Openrouter account: log in with your Openrouter API key

get_mycontent:

• google sheets account: Log into your google drive account where your Database template is located.

• Spreadsheet ID: Find your Database template

• Worksheet ID: Choose My Content

my_links:

• google sheets account: Log into your google drive account where your Database template is located.

• Spreadsheet ID: Find your Database template

• Worksheet ID: Choose Links

• Range: B2:C14

tweet_generation:

• POST: https://openrouter.ai/api/v1/chat/completions

• Openrouter account: log in with your Openrouter API key

• Body: This is a bit complicated. Do not screw up the formatting. Rewrite specifically the section to make it work for your brand, content and links

delete_rows:

• google sheets account: Log into your google drive account where your Database template is located.

• Spreadsheet ID: Find your Database template

• Worksheet ID: Choose Full Tweets

• Start index: 1

• End index: 40

add_multiple_rows1:

• google sheets account: Log into your google drive account where your Database template is located.

• Spreadsheet ID: Find your Database template

• Worksheet ID: Choose Full Tweets

• Row Values:

  • {{steps.tweet_generation.$return_value.choices[0].message.content.split("\n\n").map(tweet => [tweet])}}