Google Docs
6 sonuç — tümü kaynağa bağlı n8n referansı
Generate personalized franchise PDF letters from Excel with Google Drive and Docs
Quick overview This workflow collects an uploaded XLSX list of franchise owners via an n8n form, then uses Google Drive and Google Docs to generate a personalized letter for each row and saves the resulting PDF files back to a Google Drive folder. How it works Receives a form submission with an uploaded .xlsx file containing franchise owner details. Extracts rows from the Excel file into individual items. Iterates through each row in batches to process one franchise record at a time. Copies a Google Docs template in Google Drive and names the new document using the franchise name. Replaces placeholders in the copied Google Doc (owner, franchise, city, fee, and today’s date) with values from the current Excel row. Downloads the updated Google Doc as a PDF. Uploads the generated PDF to the target Google Drive folder and continues until all rows are processed. Setup Connect Google Drive OAuth2 credentials and set the template file ID and destination folder in the Google Drive copy/upload steps. Connect Google Docs OAuth2 credentials and ensure the template contains the placeholders (for example: [Dear Owner], [Franchise], [City], [Fee], [Date Today]). Ensure the uploaded XLSX has colu
WGenerate Automated GST Reports with GST Insights API and Google Docs
📊 GST Data Analytics Automation Flow with Google Docs Reporting Description: Streamline GST data collection, analysis, and automated reporting using the GST Insights API and Google Docs integration. This workflow allows businesses to automate the extraction of GST data and directly generate formatted reports in Google Docs, making compliance easier. ⚙️ Node-by-Node Explanation On form submission Triggers the automation whenever a user submits the GST-related data (like GSTIN) via a web form. It collects all necessary input for further processing in the workflow. Fetch GST Data Using GST Insights API Sends a request to the GST Insights API to fetch GST data based on the user's input. This is done via a POST request that includes the required authentication and the inputted GSTIN. Data Reformatting This node processes and structures the raw GST data received from the API. The reformatting ensures only the essential information (e.g., tax summaries, payment status, etc.) is extracted for reporting. Google Docs Reporting Generates a Google Docs document and auto-populates it with the reformatted GST data. The report is structured in a clean format, ready for sharing or downloading. 💡
WGenerate Automated SEO Reports with RapidAPI's SEO Analyzer and Google Docs
Automated SEO Website Audit with n8n, Google Docs & RapidAPI's SEO Analyzer Description: Use n8n to automate SEO audits with the Website SEO Analyzer and Audit AI from RapidAPI. Capture a URL, run a full audit, and export a structured SEO report to Google Docs — all without manual steps. ⚙️ Node-by-Node Explanation 🟢 formTrigger — On Form Submission Starts the workflow when a user submits a URL through a form. Collects the website to be analyzed. 🌐 httpRequest — Website Audit Sends the submitted URL to the Website SEO Analyzer and Audit AI via a POST request. Fetches detailed SEO data, including meta tags, keyword usage, and technical performance. 🧠 code — Reformat Transforms raw JSON from the Website SEO Analyzer and Audit AI into a structured Markdown summary. Organizes insights into sections like Metadata, Keyword Density, Page Performance, and Security. 📄 googleDocs — Add Data In Google Docs Automatically inserts the formatted SEO audit report into a pre-connected Google Docs file. Allows audit data to be easily shared, tracked, or archived. 🌟 Benefits ✅ Powered by **Website SEO Analyzer and Audit AI:** Leverage a reliable, cloud-based SEO tool via RapidAPI. 🔁 End-to-End
WExtract YouTube Channel Metadata to Google Docs using RapidAPI
Automate YouTube Channel Metadata Extraction to Google Docs Description: This workflow leverages the powerful YouTube Metadata API to automatically extract detailed metadata from any YouTube channel URL. Using the YouTube Metadata API, it collects information like subscribers, views, keywords, and banners, reformats it for readability, and saves it directly to Google Docs for easy sharing and record-keeping. Ideal for marketers, content creators, and analysts looking to streamline YouTube channel data collection. By integrating the YouTube Metadata, this workflow ensures accurate and up-to-date channel insights fetched instantly from the source. Node-by-Node Explanation 1. On form submission Triggers the workflow when a user submits a YouTube channel URL via a web form, starting the metadata extraction process. 2. YouTube Channel Metadata (HTTP Request) Calls the YouTube Metadata API with the provided channel URL to retrieve comprehensive channel details like title, subscriber count, and banner images. 3. Reformat (Code) Transforms the raw API response into a clean, formatted string with emojis and markdown styling for easy reading and better presentation. 4. Add Data in Google Doc
WAnalyze Webpages with Landing Page Analyzer AI & Generate Google Docs Reports
Analyze Webpages with Landing Page Analyzer AI & Generate Google Docs Reports (CRO) Description This workflow integrates the Landing Page Analyzer AI to automatically audit landing pages, format the insights into a conversion-focused report, and save it directly into Google Docs. It leverages the Landing Page Analyzer AIto grade your page, highlight strengths, and suggest improvements—all without manual steps. Nodes Explanation On form submission Captures the URL of the landing page entered by the user to trigger the workflow. Serves as the entry point to pass the URL to the Landing Page Analyzer AI. WebPage Analyzer (API Call via RapidAPI) Sends the URL to the Landing Page Analyzer AI for audit data. Retrieves key analytics: grade, score, suggestions, strengths, and conversion metrics. Reformat (Code Node) Converts the raw JSON from the Landing Page Analyzer AI into structured Markdown. Builds sections for grade, overall score, suggestions, strengths, and score breakdown. Upload In Google Docs Inserts the formatted Markdown report into a predefined Google Document. Ensures the audit output from the Landing Page Analyzer AI is saved and shareable. Benefits of This Workflow Hands-Fr
WCompare Local Ollama Vision Models for Image Analysis using Google Docs
Compare Local Ollama Vision Models for Image Analysis using Google Docs Process images using locally hosted Ollama Vision Models to extract detailed descriptions, contextual insights, and structured data. Save results directly to Google Docs for efficient collaboration. Who is this for? This workflow is ideal for developers, data analysts, marketers and AI enthusiasts who need to process and analyze images using locally hosted Ollama Vision Language Models. It’s particularly useful for tasks requiring detailed image descriptions, contextual analysis, and structured data extraction. What problem is this workflow solving? / Use Case The workflow solves the challenge of extracting meaningful insights from images in exhaustive detail, such as identifying objects, analyzing spatial relationships, extracting textual elements, and providing contextual information. This is especially helpful for applications in real estate, marketing, engineering, and research. What this workflow does This workflow: Downloads an image file from Google Drive. Processes the image using multiple Ollama Vision Models (e.g., Granite3.2-Vision, Gemma3, Llama3.2-Vision). Generates detailed markdown-based descript