Add Netlify form submissions to Airtable
This workflow demonstrates how to use the Netlify Trigger node to capture form submissions and add it Airtable. You can reuse the workflow to add the data to another similar database by replacing the Airtable node with the corresponding node. Netlify Trigger node: This node triggers the workflow when a new form is submitted. Select your site from the Site Name/ID dropdown list and the form from the Form ID dropdown list. Set node: This node extract the required data from the Netlify Trigger node. In this example, we only want to add the Name, Email, and Role of the user. Airtable node: This node appends the data to Airtable. If you want the data to Google Sheets or a database, replace this node with the corresponding node.
By Harshil AgrawalAutomated blog content generation with GPT-4o from Google Trends to WordPress
Automated Blog Content Generation from Google Trends to WordPress This n8n workflow automatically generates SEO-friendly blog content based on trending topics from Google Trends and publishes it to WordPress. Perfect for content creators, bloggers, and digital marketers who want to stay on top of trending topics with minimal manual effort. Who's it for Content creators who need fresh, trending topic ideas Bloggers looking to automate their content pipeline Digital marketers wanting to capitalize on trending searches WordPress site owners seeking automated content generation SEO professionals who want to target trending keywords How it works The workflow operates on a scheduled basis (daily at 8:45 PM by default) and follows this process: Trend Discovery: Fetches the latest trending searches from Google Trends for a specific country (Iran by default) Content Research: Performs Google searches on the top 3 trending topics to gather detailed information AI Content Generation: Uses OpenAI's GPT-4o model to create SEO-friendly blog posts based on the trending topics and search results Structured Output: Ensures the generated content has proper title and content structure Auto-Publishing: Automatically creates draft posts in WordPress The AI is specifically prompted to create engaging, SEO-optimized content without revealing the automated sources, ensuring natural-sounding blog posts. How to set up Install required community node: n8n-nodes-serpapi for Google Trends and Search functionality Configure credentials: SerpApi: Sign up at serpapi.com and add your API key OpenAI: Add your OpenAI API key for GPT-4o access WordPress: Configure your WordPress site credentials Customize the country code: Change the "Country" field in the "Edit Fields" node (currently set to "IR" for Iran) Adjust the schedule: Modify the "Schedule Trigger" to run at your preferred time Test the workflow: Run it manually first to ensure all connections work properly Requirements SerpApi account (for Google Trends and Search data) OpenAI API access (for content generation using GPT-4o) WordPress site with API access enabled How to customize the workflow Change target country: Modify the country code in the "Edit Fields" node to target different regions Adjust content quantity: Change the limit in the "Limit" node to process more or fewer trending topics Modify AI prompt: Edit the prompt in the "Basic LLM Chain" node to change writing style or focus Schedule frequency: Adjust the "Schedule Trigger" for different posting frequencies Content status: Change from "draft" to "publish" in the WordPress node for immediate publishing Add content filtering: Insert additional nodes to filter topics by category or keywords
By IranServer.comAutomate lead qualification with AI voice calls using GPT-3.5, Notion and Vapi
Website Leads to Voice Demo and Scheduling Creator: Summer Chang AI Booking Agent Setup Guide Overview This automation turns your website into an active booking agent. When someone fills out your form, it automatically: Adds their information to Notion AI researches their business from their website Calls them immediately with a personalized pitch Updates Notion with call results Total setup time: 30-45 minutes What You Need Before starting, create accounts and gather these: n8n account (cloud or self-hosted) Notion account - Free plan works duplicate my notion template OpenRouter API key - Get from openrouter.ai Vapi account - Get from vapi.ai Create an AI assistant Set up a phone number Copy your API key, Assistant ID, and Phone Number ID How It Works The Complete Flow Visitor fills form on your website Form submission creates new record in Notion with Status = "New" Notion Trigger detects new record (checks every minute) Main Workflow executes: Fetches lead's website AI analyzes their business Updates Notion with analysis Makes Vapi call with personalized intro Call happens between your AI agent and the lead When call ends, Vapi sends webhook to n8n Webhook Workflow executes: Fetches call details from Vapi AI generates call summary Updates Notion with results and recording
By SummerDownload Spotify music to Google Drive with automatic logging in sheets
Spotify Music Downloader: Effortless Music Downloading from Spotify Description: The Spotify Music Downloader is an automation flow that allows users to easily download music from Spotify tracks. By leveraging the powerful Spotify Downloader API, the flow downloads Spotify tracks, uploads them to Google Drive, and logs the details to Google Sheets for better management. With this tool, you can save time and effort while enjoying the convenience of direct downloads and automatic organization. --- Use Case: Music Enthusiasts: Easily download your favorite Spotify tracks and store them in Google Drive. Content Creators: Automate the process of storing and tracking downloaded music files. Organizational Automation: Store download links and file sizes in Google Sheets to track downloads systematically. Spotify Users: Provides a hassle-free way to access and organize your Spotify music offline. Benefits: Simple & Automated: Easily download and organize music from Spotify with minimal effort. Seamless Integration: Directly integrates with Google Drive for storage and Google Sheets for tracking. Fast: Uses the Spotify Downloader API to quickly fetch and download the tracks. Track Downloads: Keep a record of each download, including size, download link, and other details. Google Drive Storage: Automatic storage of downloaded tracks in your Google Drive, making it easy to access files anytime. --- Node-by-Node Explanation: On Form Submission: The flow starts when the user submits a Spotify track URL through a form. HTTP Request (Spotify Downloader API): Sends a request to the Spotify Downloader API to retrieve the music file associated with the given Spotify URL. If (Link Validation): Ensures that the provided Spotify URL is not empty. If1 (Success Validation): Checks if the API response was successful. Download Music: Downloads the music file from the provided Spotify link using the fetched download URL. Google Drive: Uploads the downloaded music file to Google Drive. Google Sheets: Logs the successful download details (like URL, download link, size, and timestamp) to Google Sheets. Code (File Size Calculation): Calculates the file size of the downloaded music file in MB. Wait: Introduces a delay to ensure that the upload process to Google Drive is complete before continuing. Wait1: Another wait node to allow additional time between the various steps in the flow. Google Sheets1 (Success Logs): Adds a new record for a successful download to a Google Sheet. Google Sheets2 (Failed Logs): Records failed download attempts in a secondary Google Sheet. --- By utilizing this flow, you can automate the process of downloading music from Spotify and storing it in Google Drive while keeping track of every download in Google Sheets. It's an ideal solution for music lovers, content creators, or anyone looking to automate their music download and storage process with ease. Create your free n8n account and set up the workflow in just a few minutes using the link below: đ Start Automating with n8n Save time, stay consistent, and grow your LinkedIn presence effortlessly!
By Evoort SolutionsSync Google Sheets contacts to SeaTable with update/insert logic
Keep your Google Sheets contacts in sync with SeaTable Update or Insert records in SeaTable How it works Use a Google Sheet as your central contact list. For each contact in the sheet: Check if the record already exists in SeaTable (based on email). If it exists â update the record. If it doesnât â insert the new contact. How to use Copy the Google Sheet Template Link. Get the Google Sheet ID (the string between d/ and /edit). In the workflow, set the Sheet ID in the settings node. In SeaTable, create or update a base with a Table1 containing these fields: email firstname lastname company Configure your Google Sheets and SeaTable credentials in n8n. Add your own contacts to the Google Sheet & run the workflow Requirements Google credentials (for Sheets access) SeaTable account (Cloud) n8n (tested on version 1.105.2, Ubuntu) Example use cases Maintain a central CRM-like database in SeaTable. Ensure consistent contact data when collecting leads in Google Sheets. Automate record deduplication (prevent duplicate entries). Need Help? Join the discussion here or contact me directly on LinkedIn. Ask the community in the n8n Forum.
By Stéphane Heckel