Google Sheets Google Drive

Generate UGC ads from Google Sheets with Fal.ai models (nano-banana, WAN2.2, Veo3)

Transform static spreadsheet data into dynamic UGC-style video ads by orchestrating advanced Fal.ai and Gemini models. This automated pipeline generates high-quality images and short cinematic clips, manages cloud storage on Google Drive, and updates your records in real-time. It serves as a powerful production engine for teams needing to scale personalized creative assets across social media platforms.

Run this with your team's AI

What This Recipe Does

The Gemini Content Generation template streamlines the production of high-quality written assets by bridging the gap between your structured data and advanced artificial intelligence. This automation allows business teams to transform simple prompts or data points stored in Google Sheets into fully developed articles, reports, or product descriptions using Google's Gemini AI. By eliminating the manual process of copy-pasting between documents and AI interfaces, your team can scale content production without increasing headcount. The system automatically handles batch processing and file conversion, ensuring that even large-scale projects are managed efficiently. It organizes outputs directly into Google Drive, creating a centralized repository of AI-generated content that is ready for review and publication. This workflow is particularly valuable for organizations looking to maintain a consistent brand voice across hundreds of assets while significantly reducing the time spent on initial drafting and data entry. It provides a reliable bridge between raw information and polished, professional content.

What your team gets

Something anyone can use

Forms and dashboards, so it is not a script only one person understands

It keeps running

Runs on your schedule in the cloud, so it does not stop when a laptop closes

Your other tools can call it

Endpoints, so the rest of your stack can trigger the same work

Accounts connected once

Google Sheets, Google Drive connected for the team, not per person

How It Works

  1. 1

    Open the recipe and connect your accounts

    Connect Google Sheets and Google Drive once, in your team cloud, and nobody has to do it again on their own machine

  2. 2

    Tell your own agent what is different about your process

    Claude, ChatGPT, Cursor, whichever your team already uses. It adapts the recipe to how you actually work

  3. 3

    Run it, then leave it running

    It lives in your team cloud, so it keeps going after you close the laptop and every teammate's AI can use it

Who Uses This

Frequently Asked Questions

What accounts do I need to use this automation?

You will need a Google Workspace account for Google Sheets and Drive access, along with an API key for Google Gemini to handle the content generation.

Can I control the tone and style of the generated content?

Yes. You can define specific instructions and brand guidelines within the workflow to ensure the AI output aligns with your professional standards.

How does the system handle large amounts of data?

The workflow includes batch processing and wait steps to ensure that high volumes of data are processed reliably without hitting rate limits or crashing.

Where are the final documents saved?

All generated content is converted into files and automatically uploaded to a designated folder in your Google Drive for easy access and collaboration.

Coming from n8n?

This recipe uses nodes like ManualTrigger, StickyNote, GoogleSheets, ConvertToFile and 12 more. On Runwork, you don't need to learn n8n's workflow syntax. Describe what you want to your own AI agent in plain English.

ManualTrigger StickyNote GoogleSheets ConvertToFile Set HttpRequest Wait Code GoogleDrive Langchain.openAi If Langchain.agent SplitInBatches Switch Langchain.outputParserStructured Langchain.lmChatOpenAi

Based on n8n community workflow. View original

Related Recipes

Google Drive Pinecone

Build a document QA system with Google Drive, Pinecone, and OpenAI RAG

This automation streamlines document management by instantly reacting to file changes within your Google Drive. Instead of manually monitoring folders or waiting for notifications, this workflow detects new or updated files and triggers immediate downstream actions. For businesses handling high volumes of documentation, this ensures that team members are alerted the moment a contract is uploaded, a report is edited, or a client submits a project brief. By converting Google Drive into an active participant in your workflow, you eliminate the latency between document creation and business action. This results in faster response times, improved project momentum, and the removal of administrative bottlenecks that typically slow down collaborative environments. Whether you are managing legal documents, marketing assets, or internal reports, this automation provides a reliable bridge between your storage system and your operational processes.

See the recipe
Http Jotform Google-gemini Jina AI

Automate vendor due diligence research with Gemini & Jina AI

This AI Safety and Compliance automation provides a robust framework for organizations to vet content and data against internal policies and regulatory standards. By utilizing a structured form trigger, the workflow captures submissions and subjects them to an intelligent analysis process powered by Jina AI. It evaluates inputs for potential risks, compliance violations, or safety concerns, ensuring that every piece of data moving through your pipeline adheres to predefined safety protocols. The system includes built-in wait states and conditional logic to allow for human-in-the-loop verification when necessary, finally consolidating all findings into a centralized Google Sheets repository for auditing. This automation eliminates the manual bottleneck of compliance reviews, reduces the risk of human error in safety assessments, and provides a transparent audit trail for stakeholders and regulators.

See the recipe
Langchain.chatTrigger Langchain.lmChatOpenAi Langchain.memoryBufferWindow Langchain.agent +10

AI-powered document chat with Nextcloud files using LangChain and OpenAI

This AI-driven document management automation transforms how your organization interacts with stored data. By integrating a conversational AI interface with NextCloud, this workflow allows team members to query, extract, and analyze information from files using natural language. Instead of manually searching through folders and reading dozens of documents to find specific details, users can simply ask questions and receive structured summaries or specific data points instantly. The system intelligently routes requests, processes various file types through automated extraction, and aggregates results into a cohesive response. This significantly reduces the time spent on administrative research and ensures that critical information trapped in static documents becomes an accessible, actionable asset for your entire team. By bridging the gap between raw file storage and intelligent retrieval, this automation empowers better decision-making and accelerates project timelines.

See the recipe
Http Google-gemini Jotform

Generate product images & videos with Gemini AI, DeepSeek, and GoAPI for e-commerce

This automated content generation system streamlines the transition from raw data to production-ready assets. By integrating powerful web requests and HTML processing, the workflow automatically fetches, structures, and formats content based on your specific requirements. The inclusion of a Form Trigger allows team members to initiate content requests instantly, while the built-in logic handling ensures that data is validated and converted into the correct file formats before delivery. To ensure reliability in business operations, the system features a dedicated error-handling mechanism that sends immediate notifications via Discord if a process requires attention. This eliminates the manual overhead of constant monitoring and allows your creative team to focus on strategy rather than data entry. By standardizing the content creation pipeline, businesses can maintain a consistent brand voice and accelerate their publishing schedule without increasing headcount or technical complexity.

See the recipe

Run this with the AI your team already uses

Your agent adapts it, your team cloud keeps it running, and everyone's AI can find it.

Open this recipe in Runwork