Sync Shopify orders with your Zendesk contacts
This workflow automatically syncs Shopify orders with your Zendesk contacts. Using this workflow, the Shopify email ID, phone number ID and order information will be added or updated to Zendesk contacts. Prerequisites Shopify account and Shopify credentials Zendesk account and Zendesk credentials How it works Shopify Trigger starts the workflow whenever a customer`s data is updated. Zendesk Node then searches the contact by email address. Set node keeps only the UserId and email of the contact. Merge by Key node combines the Shopify and Zendesk data. If node splits the workflow conditionally, check if the contact already exists or not. If the user exists, Zendesk node updates its contact data. If the user does not exist, Zendesk node creates a new contact.
By n8n TeamCreate workflow inventory dashboard with n8n API and Google Sheets
This workflow provides a powerful way to automatically document and maintain an inventory of all your n8n workflows in a Google Sheet. By running on a schedule or manually, it fetches details about every workflow on your instance, processes the key information, and then populates a spreadsheet. This creates a centralized, up-to-date dashboard for auditing, monitoring, and understanding your automation landscape. Who is this for? This workflow is ideal for n8n administrators, developers, and teams who manage multiple workflows. If you need a clear and simple way to track all your automations, their components, and their statuses without manually checking each one, this template is for you. It's particularly useful for maintaining technical documentation, auditing node usage across your instance, and quickly finding specific workflows. What problem is this workflow solving? As the number of workflows on an n8n instance grows, it becomes challenging to keep track of them all. Questions like "Which workflows use the HubSpot node?", "Which workflows are inactive?", or "When was this workflow last updated?" become difficult to answer. This workflow solves that problem by creating a single source of truth in a Google Sheet. It automates the process of cataloging your workflows, saving you time and ensuring your documentation is always current. What this workflow does Triggers Execution: The workflow can be initiated either on a set schedule (via the Scheduled Start node) or manually (via the Manual Start node). Fetches All Workflows: The Get All Workflows node connects to your n8n instance via the API to retrieve a complete list of your workflows and their associated data. Processes Workflows Individually: The Loop Through Each Workflow node iterates through each retrieved workflow one by one so they can be processed individually. Extracts Key Information: The Extract Workflow Details node uses custom code to process the data for each workflow, extracting essential details like its name, ID, tags, and a unique list of all node types it contains. Updates Google Sheet: The Add/Update Row in Google Sheet node then takes this information and appends or updates a row in your designated spreadsheet, using the workflow ID as a unique key to prevent duplicates. Waits and Repeats: The Pause to Avoid Rate Limits node adds a short delay to prevent issues with API limits before the loop continues to the next workflow. Setup Configure Get All Workflows Node: Select the Get All Workflows node. In the 'Credentials' section, provide your n8n API credentials to allow the workflow to access your instance's data. Prepare Your Google Sheet: Create a new Google Sheet. Set up the following headers in the first row: id, title, link, tags, nodes, CreatedAt, UpdatedAt, Active, Archived. Configure Add/Update Row in Google Sheet Node: Select the Add/Update Row in Google Sheet node. Authenticate your Google account in the 'Credentials' section. In the 'Document ID' field, enter the ID of your Google Sheet. You can find this in the sheet's URL (e.g., .../spreadsheets/d/THISISTHE_ID/edit). Select your sheet from the 'Sheet Name' dropdown. Under 'Columns', ensure the id field is set as the 'Matching Columns' value. This is crucial for updating existing rows correctly. Activate the Workflow: Choose your preferred trigger. You can enable the Schedule Trigger to run the sync automatically at regular intervals. Save and activate the workflow. How to customize this workflow to your needs Track Different Data: You can modify the Extract Workflow Details node to extract other pieces of information from the workflow JSON. For example, you could parse the settings object or count the total number of nodes. Remember to add a corresponding column in your Google Sheet and map it in the Google Sheets node. Add Notifications: Add a notification node (like Slack, Discord, or Email) after the Loop Through Each Workflow node (in the second output) to be alerted when the sync is complete or if an error occurs. Filter Workflows: You can add an IF node after the Loop Through Each Workflow node to filter which workflows get added to the sheet. For instance, you could choose to only log active workflows ({{ $('Loop Through Each Workflow').item.json.active }} is true) or workflows containing a specific tag. Adjust Wait Time: The Pause to Avoid Rate Limits node is set to pause between each entry. You can adjust this time or remove it entirely if you have a small number of workflows and are not concerned about hitting API rate limits.
By PollupAIAnalyze website backlinks with Top Backlink Checker API and Google Sheets logging
Backlink Checker with Google Sheets Logging (Seo) Description: This workflow helps you analyze top backlinks using Semrush API and logs the results directly into Google Sheets for easy SEO tracking and reporting. It integrates the Top Backlink Checker API from RapidAPI, providing in-depth backlink analysis, and combines that with Google Sheets for efficient data storage and tracking. Node-by-Node Explanation: On form submission Captures the website URL submitted by the user through a form. This node triggers the workflow when the form is filled with a website URL. The Top Backlink Checker API (via RapidAPI) is used to check backlinks after this step. Check webTraffic Sends a request to the Top Backlink Checker API to gather traffic data for the submitted website. This includes important metrics like visits, bounce rate, and more, which will later be stored in Google Sheets for analysis. Reformat output Extracts and re-formats the traffic data received from the Top Backlink Checker API. This node cleans and structures the raw data for easier processing, ensuring it is usable for later stages in the workflow. Reformat Processes the backlink data received from the Top Backlink Checker API (RapidAPI). The data is reformatted and structured to be added to Google Sheets for storage, making it easier to analyze. Backlink overview Appends the re-formatted backlink overview data into a Google Sheets document. This stores important backlink information like source URLs, anchor texts, and more, making it available for later analysis and reporting. Backlinks Appends detailed backlink data, including target URLs, anchors, and internal/external links, into Google Sheets. This helps track individual backlinks, their attributes, and page scores, allowing for deeper SEO analysis and reporting. Benefits and Use Cases: Benefits: Backlink Tracking: The integration of the Top Backlink Checker API helps you track all the backlinks associated with a website. You can get insights on the source URL, anchor text, first and last seen, and more. Traffic Insights: By integrating Top Backlink Checker API, this workflow allows you to monitor important website traffic data such as visits, bounce rates, and organic reach, helping with SEO strategies. Automated Google Sheets Logging: All traffic and backlink data is logged automatically into Google Sheets for easy access and future analysis. This avoids manual data entry and ensures consistency. Efficient Workflow: The automation provided by n8n streamlines your SEO analysis workflow, ensuring that data is formatted, structured, and updated without any manual intervention. Use Cases: SEO Reports: Generate regular SEO reports by tracking backlinks and traffic data automatically from Semrush and Top Backlink Checker, saving time and ensuring accurate reporting. Competitor Analysis: Analyze your competitors’ backlinks and traffic to stay ahead in SEO rankings by leveraging data from the Top Backlink Checker API. Backlink Management: Use the data from Top Backlink Checker API to assess the health of backlinks, ensuring that high-value backlinks are tracked, and toxic backlinks are identified for removal or disavow. SEO Campaign Tracking: Monitor how backlinks and website traffic evolve over time to evaluate the effectiveness of your SEO campaigns, keeping all your data in Google Sheets for easy tracking.
By Sk developer Bulk YouTube channel content analysis with Apify & DeepSeek AI to Google Sheets
🎓📺 Watching top YouTubers is now a mainstream way to learn, but watching dozens—or even hundreds—of videos isn’t realistic. This workflow gives learners a fast way to grasp an entire creator’s catalog at a glance. 📄🔗 Demo Google Sheet: click me --- 🧠🔍 YouTube Channel Research & Summarization Workflow 👥 Who’s it for 📚 Learners and educators who want a fast overview of a creator’s entire catalog. 🧩 Research, SEO, and content ops teams building an intelligence layer on top of YouTube channels. ⚙️ How it works 📝 Collects parameters via a Form Trigger. 🕷️ Launches an Apify YouTube Scraper, polls for completion, and fetches the final dataset. 💾 Saves the raw JSON to Google Drive, reloads it, and processes records in batches. 🗣️ Auto-selects English subtitles when available, extracts core metadata, and feeds transcript + metadata to an AI Summarization Agent. 📧 Sends a Gmail completion notification when done. 🛠️ How to set up 🔑 Connect credentials (once) 🗂️ Google Drive 📊 Google Sheets (OAuth enabled) ✉️ Gmail 🧠 DeepSeek API (or alternative LLM); Apify API (YouTube scraper actor) 📝 Configure the form 🔗 YoutuberMainPageURL (e.g., https://www.youtube.com/@n8n-io) 🔢 Totalnumbervideo (tip: use the channel’s current total to crawl all) 🏷️ Storing_Name (used for the Drive filename & the Sheet tab) 🔑 Apify_API (Apify provides $5 free credit per month, which can crawl ~1,000 YouTube videos → https://console.apify.com/) 📧 Email 📁 Point Sheets & Drive 🔗 Create a Google Sheet and link it to all Google Sheets–related nodes. 💽 Select a Drive folder to save raw CSV backups (optional). 🎛️ How to customize the workflow 🈯 Subtitle logic: Extend the language selector SelectSubtitleLanguage to choose English, Mandarin, or another language. 🔔 Notifications: Customize the Gmail subject/body, or add Slack/Teams alerts on success/failure with basic run stats. 📬 Need help? Contact me <owenlzyxg@gmail.com>
By OwenLeeTransform spreadsheet data into smart charts with OpenAI, QuickChart & Google Drive
Overview of the n8n Workflow This n8n workflow automates the transformation of spreadsheet data into professional charts and graphs using AI-driven analysis. Triggered via Slack, it processes uploaded files (Excel, CSV, Google Sheets, or Drive links), interprets the data with an AI agent to determine the best visualization type (e.g., bar, line, pie, doughnut, or bubble charts), generates images via QuickChart, uploads them to Google Drive, and delivers the results back to the user in Slack with titles and shareable links. It maintains conversation context in Postgres for seamless multi-turn interactions and handles audio or text inputs for chart requests. What this workflow does: Hooks up to Slack for seamless spreadsheet uploads Automatically extracts your data and generates bar charts, line graphs, bubble charts, and more Delivers stunning visualizations straight back to you in Slack Makes it easy to spot trends, patterns, and insights—on demand --- How it Works • Users upload spreadsheets or share links via Slack, along with a natural language request (e.g., "Create a bar chart of sales by month"). • The workflow detects file types, extracts and aggregates data, then uses an AI agent to parse the request and select an appropriate chart type. • Data is formatted and sent to QuickChart's API to generate the visualization image. • Images are uploaded to Google Drive, and a confirmation message with titles and links is sent back to Slack. --- Set Up Steps Setup takes about 15-30 minutes, mainly for credential configuration. Detailed node instructions are in the workflow's sticky notes—focus on pasting API keys and testing triggers. Once cloned, the workflow runs plug-and-play; only tweak credentials and optional prompts as needed. --- ⚙️ Turn Spreadsheets Into Charts & Graphics Automate turning uploaded spreadsheets into AI-generated charts (bar, line, pie, etc.) via Slack, with results shared as Google Drive links. 🧑💻 Author: LeeWei --- 🚀 Steps to Connect: Slack Bot Setup Create a Slack app at api.slack.com/apps and add scopes for chat:write, files:read, channels:read. Generate a Bot User OAuth Token and paste it into the Slack Trigger node's credentials in n8n. Invite the bot to your desired channel for file uploads and messages. OpenAI API Key Sign up at platform.openai.com and generate an API key. Paste this key into the OpenAI (gpt-4o-mini) node's credentials. 💡 For cost efficiency, monitor usage—basic charts use minimal tokens. Postgres Database Connection Set up a Postgres instance (e.g., via Supabase or your host) with a table named n8nrodgerchat for chat history. Add connection details (host, database, user, password) to the Postgres nodes' credentials. This enables thread memory; skip if not using multi-turn chats (but recommended for context). Google Sheets & Drive Setup Create OAuth2 credentials at console.cloud.google.com with scopes for Sheets (read) and Drive (upload, share). Paste the credentials into the Google Sheets and implied Drive upload nodes. Test by sharing a sample sheet—ensures data extraction and image storage work. QuickChart Integration No API key needed for free tier (up to 500 charts/month); visit quickchart.io to confirm. For production (100k+ charts/month), upgrade to corporate plan ($40/month) and add any auth if required in the HTTP Request node. The node is pre-configured for chart generation—edit URL params only for custom styling. --- Plug and Play Instructions Clone the workflow JSON directly into n8n—all nodes (triggers, AI agents, extractors, switches) are pre-wired and ready. No re-setup needed beyond the steps above. Key editable fields (found in sticky notes): AI Agent Node: System Prompt Customize the chart interpretation (default: auto-selects bar/line/pie/etc. based on data). Example: Change to prioritize "scatter plots for correlations" if needed. Switch Nodes (File Detection) Add rules for new formats (e.g., .ods for OpenDocument) in the conditions for XLS/XLSX/CSV/Sheets/Drive. HTTP Request Node (QuickChart) Tweak chart params like width=800&height=600 for size, or colors via ?chart=... for branding. Let User Know Upload Complete: Text Adjust the confirmation message template for tone (e.g., add emojis or custom phrasing). Test with a sample Slack message: "Make a line graph from this sales CSV over months." Results appear instantly with links. --- Potential Customizations Add Chart Types: Duplicate a chart branch (e.g., Line Graph) and integrate new QuickChart endpoints for scatter or funnel charts. Switch AI Provider: Replace OpenAI with OpenRouter in the Chat Model node for alternative LLMs. Batch Size: Edit the Loop Over Items node's batch for larger datasets (default handles small files efficiently). Error Handling: Add IF nodes post-extraction to notify on invalid data. --- Considerations and Improvements Rate Limits: QuickChart free tier suits testing; scale to paid for heavy use. OpenAI tokens add up for complex data. File Limits: Supports up to ~10MB uploads; for larger, preprocess externally. Privacy: Data passes through OpenAI—review for sensitive info. Enhancements: Integrate image OCR for scanned tables, or export to PDF for reports. This workflow streamlines data viz without coding, perfect for teams analyzing trends on the fly. Questions? Drop a Slack message in your bot channel!
By LeeWei