Generate AI Sales Pitches from Website URLs with GPT-4o and Google Sheets

This n8n workflow automates the process of generating sales pitches for websites using OpenAI's GPT-4o model and storing them in a Google Sheet. It's designed to streamline lead qualification and personalized outreach by quickly creating compelling pitch content based on website information.

What it does

This workflow performs the following steps:

1. Manual Trigger: Starts the workflow manually, allowing you to initiate the pitch generation process on demand.
2. Google Sheets (Read): Reads data from a specified Google Sheet. This sheet is expected to contain a list of website URLs for which sales pitches need to be generated.
3. Loop Over Items: Processes each row (website URL) from the Google Sheet individually.
4. Edit Fields (Set): Prepares the input data for OpenAI by structuring the website URL into a prompt.
5. OpenAI (Generate Pitch): Sends the website URL to OpenAI's GPT-4o model with a prompt to generate a sales pitch.
6. Wait: Introduces a delay between OpenAI requests to prevent rate limiting issues and ensure smooth operation.
7. Edit Fields (Set Pitch): Extracts the generated sales pitch from the OpenAI response and prepares it for writing back to Google Sheets.
8. Google Sheets (Update): Writes the generated sales pitch back to the original Google Sheet, associating it with the corresponding website URL.
9. No Operation, do nothing: A placeholder node that does nothing, typically used for flow control or as a temporary endpoint during development.

Prerequisites/Requirements

To use this workflow, you will need:

• n8n Instance: A running n8n instance (self-hosted or cloud).
• Google Account: Access to Google Sheets with a spreadsheet containing website URLs.
• OpenAI API Key: An API key for OpenAI with access to the GPT-4o model.

Setup/Usage

1. Import the Workflow:
   • Copy the provided JSON code.
   • In your n8n instance, click "New" to create a new workflow.
   • Go to "Workflows" -> "Import from JSON" and paste the copied JSON.
2. Configure Credentials:
   • Google Sheets: Configure your Google Sheets credentials. You'll need to authenticate your Google account to allow n8n to read from and write to your spreadsheets.
   • OpenAI: Configure your OpenAI credentials. You'll need to provide your OpenAI API Key.
3. Prepare your Google Sheet:
   • Create a Google Sheet with a column for "Website URL" (or similar).
   • Ensure there's another column where the generated "Sales Pitch" can be written back.
   • In the "Google Sheets" nodes, specify the Spreadsheet ID and the Sheet Name you want to use.
   • In the "Google Sheets (Read)" node, ensure the "Range" is set correctly to read your URLs.
   • In the "Google Sheets (Update)" node, ensure the "Update Key" and "Update Column" are correctly configured to match your sheet's structure (e.g., update the "Sales Pitch" column based on the "Website URL").
4. Customize OpenAI Prompt (Optional):
   • In the "OpenAI (Generate Pitch)" node, you can customize the prompt to refine the sales pitch generation according to your specific needs (e.g., target audience, pitch length, specific aspects to highlight).
5. Activate and Execute:
   • Activate the workflow.
   • Click "Execute Workflow" on the "Manual Trigger" node to run it.

The workflow will then read your URLs, generate pitches, and update your Google Sheet automatically.