This template streamlines your Instagram content posting workflow by connecting Google Drive for image storage, using OpenAI for AI-generated captions, and leveraging Facebook Graph API for automated publishing. Pre-requisites Before setting up this workflow, ensure you have: A Google account with access to Google Drive An OpenAI API key for AI caption generation A Facebook Developer account with Instagram Graph API access An Instagram Business or Creator account connected to a Facebook Page n8n.io account with workflow access Setup Instructions Configure Data Source Create a Google Sheet with the following columns: Name: Filename of your image in Google Drive Caption: Optional custom caption (leave empty for AI-generated captions) URL: your Video Reel or Image in Google Drive Connect Google Drive Add your Google Drive credentials in the "Google Drive" node Specify the folder path where your Instagram image/Video are stored Configure the node to retrieve image files based on filenames from your Google Sheet Set Up OpenAI Integration Add your OpenAI API key to the credentials Configure the OpenAI node to generate engaging captions based on image content Adjust temperature and model
Tags
Facebook Graph API
Google Drive
Google SheetsOpenAIRelated workflows
See all AI Automation→
Send CRM lead outreach emails with Notion, Gmail, Google Drive and OpenAI
Quick Overview This workflow watches a Notion CRM for leads ready to contact, checks Gmail to avoid duplicate outreach, then sends or drafts an email with Google Drive PDF attachments and updates the lead status in Notion, with bounce detection that marks invalid emails (using OpenAI to extract addresses). How it works Triggers when a lead page is updated in a selected Notion CRM database. Validates that the lead’s Email field looks like an email address and searches Gmail Sent for recent messages to that recipient to detect prior outreach. If the lead was already emailed and the current status is safe to overwrite, it updates the Notion lead status to “Emailed.” If the lead was not previously emailed, it downloads two PDF attachments from Google Drive, converts them to Gmail attachments, and either creates a Gmail draft for specific domains (optionally sending a Twilio SMS to a rep) or sends a generic vs personalized Gmail email based on whether a contact name exists. After sending, it waits briefly, searches Gmail for bounce messages mentioning “Address not found,” and updates the Notion record to “INVALID EMAIL” (or sets “Emailed” when the status indicates the lead is in an acti
Ask questions about a PDF using AI
The workflow first populates a Pinecone index with vectors from a Bitcoin whitepaper. Then, it waits for a manual chat message. When received, the chat message is turned into a vector and compared to the vectors in Pinecone. The most similar vectors are retrieved and passed to OpenAI for generating a chat response. Note that to use this template, you need to be on n8n version 1.19.4 or later.
Handle WhatsApp customer service chats with Google Gemini and Google Sheets
Quick Overview This workflow handles WhatsApp customer service via OpenWA, using Google Gemini and a Google Sheets knowledge base to answer personal chats, while routing conversations to a human queue in Google Sheets when escalation is needed. How it works Triggers on OpenWA WhatsApp events and ignores message reactions except for specific ✅/☑ reactions used to re-enable AI handling. Normalizes incoming event fields and processes only personal chats (IDs ending with @c.us) that are not sent by your own WhatsApp account. Checks a Google Sheets “Session Chat” list to decide whether the conversation is currently handled by a human, and only continues to AI when no active human session is found. Uses a Google Gemini chat model with short-term memory and a Google Sheets “Database Company” tool to draft a friendly Indonesian response based only on the sheet data. If the AI response does not contain the #admin escalation token, it sends the reply back to the customer via OpenWA. If the AI response contains #admin, it appends the chat to the Google Sheets “Session Chat” sheet to flag it for human follow-up. When a ✅/☑ reaction is received for a chat, it finds and deletes the corresponding