Create, Update, and Get User from Iterable
Overview
This workflow demonstrates how to manage user profiles in Iterable by performing three sequential operations: creating a user, updating their data fields, and retrieving the updated record. It's a practical example of Iterable's user lifecycle management, useful for marketing teams who need to synchronize customer data from other systems into Iterable for targeted campaigns.
Workflow Steps
-
On clicking 'execute' (Manual Trigger) — Starts the workflow when the user clicks the 'Execute Workflow' button in the n8n editor. No authentication required.
-
Iterable (Create User) — Creates a new user in Iterable using an email address as the identifier. The node is configured with:
value: The email address of the user to create (entered manually or via expression)identifier: Set to "email" to use email as the unique identifieradditionalFields: Empty (no extra fields on creation)- Authentication: Requires Iterable API Key (set in n8n credentials)
-
Iterable1 (Update User) — Updates the user created in the previous step by adding a custom data field. Configuration:
value: Dynamically references the email from the first Iterable node using={{$node["Iterable"].parameter["value"]}}identifier: "email"additionalFields.dataFieldsUi.dataFieldValues: Adds a field with key "Name" and an empty value (user should populate this)- Authentication: Same Iterable API Key credential
-
Iterable2 (Get User) — Retrieves the updated user profile to confirm the changes. Configuration:
email: References the same email from the first node via expressionoperation: Set to "get" to fetch user details- Authentication: Same Iterable API Key credential
Setup Instructions
- Iterable Account: You need an active Iterable account with API access. Generate an API key from Iterable's Settings > API Keys page.
- n8n Credentials: In n8n, create a new "Iterable API" credential and paste your API key.
- Email Value: Before running, replace the
valueparameter in the first Iterable node with a valid email address (or use an expression to pass it dynamically). - Optional: In the Iterable1 node, set the "Name" field value to an actual name (e.g., "John Doe") to see the update in action.
Use Cases & Variations
- User Onboarding: Automatically create and enrich user profiles when someone signs up via a form or API.
- Data Sync: Combine with a Schedule Trigger to periodically sync user data from a CRM or database into Iterable.
- Error Handling: Add error-handling nodes (e.g., IF node) to check if the user already exists before creating.
- Bulk Operations: Use a SplitInBatches node to process multiple users from a CSV or Google Sheet.
- Event Tracking: Extend the workflow to log events (e.g., "User Created") in Iterable after the update.
Workflow JSON
{
"id": "165",
"name": "Create, update and get a user from Iterable",
"nodes": [
{
"name": "On clicking 'execute'",
"type": "n8n-nodes-base.manualTrigger",
"position": [
310,
340
],
"parameters": {},
"typeVersion": 1
},
{
"name": "Iterable",
"type": "n8n-nodes-base.iterable",
"position": [
510,
340
],
"parameters": {
"value": "",
"identifier": "email",
"additionalFields": {}
},
"credentials": {
"iterableApi": "Iterable"
},
"typeVersion": 1
},
{
"name": "Iterable1",
"type": "n8n-nodes-base.iterable",
"position": [
710,
340
],
"parameters": {
"value": "={{$node[\"Iterable\"].parameter[\"value\"]}}",
"identifier": "email",
"additionalFields": {
"dataFieldsUi": {
"dataFieldValues": [
{
"key": "Name",
"value": ""
}
]
}
// ... truncated (copy to see full JSON)How to Import This Workflow
- 1Copy the workflow JSON above using the Copy Workflow JSON button.
- 2Open your n8n instance and go to Workflows.
- 3Click Import from JSON and paste the copied workflow.
Don't have an n8n instance? Start your free trial at n8nautomation.cloud
Related Templates
AI LinkedIn Content Creator with Perplexity Research & Auto-Posting
AI-Powered LinkedIn Content Automation Workflow Overview This workflow automates the entire LinkedIn content lifecycle — from research and ideation to image generation and scheduled posting. It uses Perplexity AI for topic research, an Anthropic Claude model as the content strategist, and OpenAI's image generation model to create branded visuals. The workflow runs on two separate schedules: one for content creation (daily) and one for publishing (twice weekly). It stores all posts in a Google Sheet for review before they go live, giving you full control over what gets published. This is ideal for founders, marketers, and content creators who want to maintain a consistent LinkedIn presence without spending hours writing, designing, and scheduling posts manually. The system learns from past content stored in Google Sheets and uses AI to generate fresh, on-brand posts that resonate with your target audience. Node-by-Node Breakdown Content Creation Pipeline (Runs Daily at 5 AM) Schedule () — No auth. Triggers the content creation workflow daily at 5:00 AM. This is the starting point for generating new post ideas. Get Past Ideas () — OAuth2. Reads all rows from the "LinkedIn Posts" sheet in the Google Sheet "AI Content Database". This provides the AI with context about previously generated posts to avoid repetition. Join Ideas () — No auth. A JavaScript code node that concatenates all past post ideas into a single text string, making it easy for the AI to reference them. LinkedIn Creator Agent () — No auth (uses connected models). This is the core AI agent that generates LinkedIn post content. It uses: - Anthropic Chat Model () — API Key auth. Uses Claude 3.7 Sonnet as the language model for content generation. - Perplexity Research () — API Key auth. A sub-workflow that uses Perplexity AI to research current topics and trends. - Structured Output Parser () — No auth. Ensures the AI output follows a structured JSON format with fields: , , and . Image Style () — OAuth2. Downloads a reference image from Google Drive that serves as the style guide for generating new images. OpenAI Image1 () — Header Auth (HTTP Header Auth). Sends a POST request to OpenAI's image generation API (gpt-image-1 model) with the reference image and a prompt describing the desired image for the LinkedIn post. Convert to File () — No auth. Converts the base64 image data from OpenAI's response into a binary file for saving to Google Drive. Save Image () — OAuth2. Uploads the generated image to a specific folder ("LinkedIn AI Posts") in Google Drive, naming it after the post title. Save Post () — OAuth2. Appends a new row to the "LinkedIn Posts" sheet with the post text, description, image URL, and status set to "review". Publishing Pipeline (Runs Every 3 Days at 2 PM) Schedule 2 () — No auth. Triggers the publishing workflow every 3 days at 2:00 PM. Get Ready Posts () — OAuth2. Filters the Google Sheet for rows where the status column equals "ready", retrieving posts that have been approved for publishing. Pick One () — No auth. Limits the output to a single post (first row) from the filtered results. Download Image () — OAuth2. Downloads the image associated with the selected post from Google Drive using the image URL stored in the sheet. Publish Post () — OAuth2. Publishes the post to LinkedIn with the text content and attached image, set to public visibility. Update Status () — OAuth2. Updates the status of the published post from "ready" to "posted" in the Google Sheet, matching by the "about" column. Setup Instructions Required Accounts & Services Google Account — For Google Sheets and Google Drive access. You'll need to create a Google Cloud Project and enable the Sheets and Drive APIs, then create OAuth2 credentials. Anthropic Account — Sign up at console.anthropic.com to get an API key for Claude 3.7 Sonnet. Perplexity AI Account — Sign up at perplexity.ai and obtain an API key for research capabilities. OpenAI Account — Sign up at platform.openai.com and get an API key for image generation. LinkedIn Account — You'll need a LinkedIn profile or company page to post to. Connect via n8n's LinkedIn OAuth integration. Configuration Steps Create a Google Sheet named "AI Content Database" with a sheet called "LinkedIn Posts" containing columns: , , , . Upload a reference image to Google Drive that represents your brand's visual style. Update the Google Sheet ID and folder IDs in the nodes to match your own. Configure all credential connections in n8n for each service. Adjust the cron schedules to match your desired posting frequency. Customize the AI system prompt in the LinkedIn Creator Agent to match your brand voice. Use Cases & Variations Primary Use Cases Personal Brand Building: Automate daily LinkedIn content for thought leaders and consultants. Agency Content Management: Manage multiple client content calendars from a single workflow. Content Repurposing: Adapt the workflow to generate content for Twitter, Instagram, or newsletters. Possible Variations Platform Swap: Replace the LinkedIn node with Twitter, Facebook, or Slack nodes. Research Source: Swap Perplexity for a Google Search API or RSS feed reader. Image Model: Use DALL-E 3 or Stable Diffusion instead of gpt-image-1. Review Workflow: Add a Slack notification node to alert you when posts are ready for review. Multi-Platform Publishing: Duplicate the publishing pipeline for different social networks. Content Calendar: Add a calendar node to schedule posts for specific dates and times.
Auto-Generate Social Posts from YouTube via Dumpling AI
🧠 Automate Social Media Content Creation from YouTube Videos This powerful workflow automatically generates platform-specific social media posts (Instagram, Facebook, LinkedIn) from YouTube videos. It takes a topic from a Google Sheet, searches for relevant YouTube videos using Dumpling AI, selects the best match with GPT-4o, fetches the transcript, and creates tailored posts with matching AI-generated images — all saved back to your Google Sheet. Perfect for content creators, social media managers, and marketers who want to repurpose YouTube content efficiently. The workflow runs on a schedule, processes one topic at a time, and marks topics as completed to avoid duplication. It combines the power of Dumpling AI for YouTube search and image generation, OpenAI's GPT-4o for intelligent content selection and copywriting, and Google Sheets for data management. 📋 Node-by-Node Breakdown Trigger Search Schedule (Schedule Trigger) — No auth required. Runs the workflow on a configurable interval (default: every hour). You can adjust the schedule in the node settings. Get Unsearched Topic from Google Sheet (Google Sheets) — OAuth2 (Google Sheets). Reads the first unsearched topic from the "YouTube Topics" sheet. Uses a filter to find rows where "Searched?" column is empty, and returns only the first match. Search YouTube via Dumpling AI (HTTP Request) — Header Auth (Dumpling AI API key). Sends a POST request to Dumpling AI's YouTube search endpoint with the topic as query. Returns video results matching the search term. Filter + Sort YouTube Videos (Code) — No auth. Custom JavaScript that extracts video data from the API response, filters for video type, sorts by published date (newest first), and returns the 3 most recent videos. Prepare Video List for AI (Aggregate) — No auth. Combines all video items into a single array for processing by the AI node. Select Best Video with GPT-4o (OpenAI) — API Key auth (OpenAI). Uses GPT-4o to analyze the search results and select the most relevant video based on the original topic and current date. Returns the best match in structured JSON format. Get Transcript (Dumpling AI) (HTTP Request) — Header Auth (Dumpling AI API key). Fetches the YouTube transcript for the selected video using Dumpling AI's transcript endpoint. Generate Posts with GPT-4o (OpenAI) — API Key auth (OpenAI). Takes the transcript and generates three platform-specific posts (Instagram, Facebook, LinkedIn) with matching image prompts. Each post is tailored to the platform's style and audience. Generate Instagram Image (Dumpling AI) (HTTP Request) — Header Auth (Dumpling AI API key). Creates an AI-generated image for the Instagram post using FLUX.1-pro model. Generate Facebook Image (Dumpling AI) (HTTP Request) — Header Auth (Dumpling AI API key). Creates an AI-generated image for the Facebook post. Generate LinkedIn Image (Dumpling AI) (HTTP Request) — Header Auth (Dumpling AI API key). Creates an AI-generated image for the LinkedIn post. Format Instagram Post (Set) — No auth. Structures the Instagram post data with platform name, content text, and image URL. Format Facebook Post (Set) — No auth. Structures the Facebook post data similarly. Format LinkedIn Post (Set) — No auth. Structures the LinkedIn post data similarly. Save Instagram Post to Sheet (Google Sheets) — OAuth2 (Google Sheets). Appends the formatted Instagram post to the "Social Media Post" sheet. Save Facebook Post to Sheet (Google Sheets) — OAuth2 (Google Sheets). Appends the formatted Facebook post to the same sheet. Save LinkedIn Post to Sheet (Google Sheets) — OAuth2 (Google Sheets). Appends the formatted LinkedIn post to the same sheet. Merge Post Results (Merge) — No auth. Combines the three post results into a single output for the final update step. Update Topic Status in Sheet (Google Sheets) — OAuth2 (Google Sheets). Marks the original topic as "Searched?" = "Yes" in the YouTube Topics sheet to prevent reprocessing. 🔧 Setup Instructions Required Accounts & Credentials: Google Account — For Google Sheets access. Create OAuth2 credentials in n8n for Google Sheets. Dumpling AI Account — Sign up at app.dumplingai.com and get your API key. Add as Header Auth credential in n8n. OpenAI Account — Get your API key from platform.openai.com. Add as API Key credential in n8n. Required Google Sheets: YouTube Topics sheet with columns: , Social Media Post sheet with columns: , , 💡 Use Cases & Variations Primary Use Cases: Content repurposing for social media managers Automated content calendar creation YouTube-to-social-media content pipeline Brand consistency across platforms Adaptation Ideas: Add more platforms (Twitter/X, TikTok, Pinterest) Schedule posts directly to social media using n8n integrations Add human review step before posting Use different AI models for image generation Add email newsletter content generation Include video thumbnail generation Add analytics tracking for post performance
Contact Form to Slack & Email Notification Workflow
This workflow automates the process of capturing contact form submissions from your website and immediately notifying your team via Slack while also sending a confirmation email to the submitter. It's designed to help businesses respond faster to leads and inquiries without manual intervention. Workflow Steps Form Submission on Website (No auth) — This node creates a simple web form that collects Name, Email, and Phone from visitors. The form is embedded on your website using the provided webhook URL. No authentication is required as it's a public-facing form. Slack (OAuth2) — Sends a formatted message to your designated Slack channel (e.g., #leads) containing the submitted details. Requires a Slack app with bot token and appropriate channel permissions. Send Email - Gmail (OAuth2) — Sends a thank-you email to the submitter using Gmail API. Requires OAuth2 credentials for a Google account. Send Email - Outlook (OAuth2) — Sends the same thank-you email via Microsoft Outlook API. Requires OAuth2 credentials for a Microsoft account. Setup Instructions Slack: Create a Slack app with chat:write scope, install it to your workspace, and add the bot to your target channel. Gmail: Enable Gmail API in Google Cloud Console, create OAuth2 credentials, and authorize the workflow. Outlook: Register an app in Azure AD, grant Mail.Send permission, and configure OAuth2 credentials. Form: Copy the webhook URL from the Form Submission node and embed it as the form action in your HTML form. Use Cases & Variations Lead capture: Replace Slack with CRM nodes (HubSpot, Salesforce) to create contacts automatically. Multi-channel notifications: Add SMS via Twilio or push notifications via Telegram. Conditional routing: Use IF nodes to route different form responses to different Slack channels or email templates. Data enrichment: Add HTTP Request nodes to enrich lead data (e.g., company info from email domain).