Connect Google Sheets and Google Docs integrations
Automate your workflows by integrating Google Sheets and Google Docs with Make, transforming data updates into real-time document changes that improve productivity and streamline operations to match your business needs.
Receives data from the MAKE_FUNCTION or INTEGROMAT functions used in a sheet. Please note, the Sheets Add-On is required.
Triggers when a cell is updated. Watches only changes made in Google Sheet app. Sheets Add-On required.
Triggers when a new row is added.
Creates a new Google document by adding the content of HTML format.
Creates a copy of an existing template document and replaces any tags e.g. {{!notfound:name}}, {{!notfound:email}}. This module also allows users to replace images by new images with URLs.
Deletes a document.
Downloads a document to a required format.
Gets a content of a document.
Inserts a new image with URL to a document. The original size of the image is entered or the image is resized as required by the user. The original image ratio is maintained.
Inserts or appends a new paragraph to an existing document.
Makes all links in a document clickable.
Performs an arbitrary authorized API call.
Replaces an existing image with a new image with URL in the document. In order to fill the original image's bounds, the new image may be scaled or cropped.
Replaces an old text by a new text in a document.
Retrieves a list of documents.
Trusted by thousands of fast-scaling organizations around the globe
Automate your work. Build something new.
Just drag and drop apps to automate existing workflows or build new complex processes. Solve problems across all areas and teams.
Build your Google Sheets and Google Docs integrations.
Integrate Google Sheets as a trigger and Google Docs as an action with Make to automate your workflows easily. With just a few clicks, data updated in Google Sheets can automatically trigger changes in Google Docs, creating dynamic documents that update in real-time. This integration allows you to define specific triggers when data in Google Sheets changes, prompting a corresponding action in Google Docs, improving your processes, reducing manual intervention, and increasing productivity. Make it straightforward to tailor these automated workflows, aligning them with your business needs for effective information management and documentation.
Creates a new conditional format rule at the given index. All subsequent rules' indexes are incremented.
Appends a new row to the bottom of the table.
Adds a new sheet.
Appends multiple rows to the bottom of the table.
Updates multiple rows.
Clears a specified range of values from a spreadsheet.
Clears a specific cell.
Clears values from a specific row.
Copies a sheet to another spreadsheet.
Popular Google Sheets and Google Docs workflows.
Explore integration of Google Sheets and Google Docs for optimized workflows and dynamic document automation with real-time data updates.
Create a Quote with Google Docs for each new row in Google Sheets.
For each new row in a Google Sheets spreadsheet, Make will automatically create a Quote with Google Docs. The template uses this [example Spreadsheet](https://docs.google.com/spreadsheets/d/18tuKaQV_8cyehugArbU0K7YOAVzWfwjavF9z1URt1Dw/edit?usp=sharing) and this [example Google Doc](https://docs.google.com/document/d/1hhH1H1oH9j4eAu6QxHYM_q0XB3S4cKbPoWAK41cRndM/edit?usp=sharing).
TRY IT ->Create a new Google Doc for every new row in Google Sheets with content from Anthropic Claude
Use this automation to generate a Google Docs document for each new row in Google Sheets, featuring a personalized message from Anthropic Claude, streamlining document creation.
TRY IT ->Append new content to Google Docs from Google Sheets with generated responses from Perplexity AI
Use this template to append data to Google Docs with Perplexity AI responses, triggered from Google Sheets streamlining content updates and AI-driven insights.
TRY IT ->Generate a new Google Docs with 2 Claude prompts, Perplexity AI and filtered Google Sheets rows
Use this automation to periodically filter Google Sheets rows and generate AI chat completions with Perplexity AI and 2 Anthropic Claude prompts, then create a Google Docs document.
TRY IT ->
+3
Traffic Funnel: Multiplatform Video Publishing & Traffic Automation (Short version)
This scenario is the first part of a powerful automation system for video creators, marketers, and social media managers. It handles the full pre-publishing cycle of your video content — from raw footage to SEO-optimized posts — and works with any platform that supports video content. ✅ What this scenario does: • Takes a video from Google Drive, no size or format restrictions. • Runs an automated transcription via the Harmoniq module. • Extracts key moments, timestamps, and converts them into platform-ready shorts. • Automatically generates: o SEO titles o Descriptions with CTAs o Hashtags and keywords o Platform-specific formatting • Publishes videos (or Shorts) with correct timing, captions, and descriptions to any platform, including: o YouTube o Instagram o TikTok o Facebook o LinkedIn o Telegram o VK, Pinterest, and more 📊 The entire flow is managed via a Google Sheet interface, so you stay in control without doing the manual work. ________________________________________ 🌍 Why it matters: This scenario is not just about automation — it's about freeing your time, scaling your reach, and unifying your content pipeline across all major video and social platforms. You no longer have to write separate descriptions, tailor hashtags, or publish manually — Harmoniq does it for you. ________________________________________ 🔗 Get both parts and full documentation at: 👉 https://kihedi.com
TRY IT ->Harmoniq Funnel: Receive transcript and save to Docs for publishing flow (2nd part)
Harmoniq Funnel is designed to provide full control over your video workflows, even at the deepest technical levels. This scenario listens for the finished transcription from Harmoniq, safely stores the full text with timestamps into a Google Doc, and connects it to your publishing system through Google Sheets. ✅ What makes Harmoniq different? Instead of just returning plain text, Harmoniq delivers structured results: Time-stamped segments Word-level timing Full plain text for flexible use This structure enables future automation of dubbing, short content creation, SEO optimization, and multilingual publishing. 🌟 Harmoniq is built to go beyond simple transcription — it powers full video systemization and scaling, preparing your content for massive reach across platforms and languages. ⚙️ Setup Requirements: Harmoniq connection Webhook setup via “Create a webhook” option in Make Google Drive and Google Sheets connections Learn more at https://www.kihedi.com
TRY IT ->Generate a new Google Docs and summarize data from Google Sheets with Perplexity and 2 ChatGPT prompts
This template will create a Google Docs document by summarizing data from Google Sheets using Perplexity AI and 2 ChatGPT prompts. Streamline data analysis and documentation with AI-driven insights.
TRY IT ->Insert a paragraph in a Google Doc with Perplexity AI and ChatGPT from Google Sheets data
Automatically generate a Google Docs document with Perplexity AI and ChatGPT responses by extracting data from Google Sheets, enhancing documentation and collaboration efficiency.
TRY IT ->Search and Filter rows in Google Sheets and append to Google Docs with Perplexity AI and ChatGPT
Automatically filter rows in Google Sheets, generate responses with Perplexity AI and ChatGPT, and append them to Google Docs for streamlined data processing and documentation.
TRY IT ->
How to setup Google Sheets and Google Docs in 5 easy steps
Log into Make
Start by logging into the Make platform to prepare for setting up your application connections.
Set up Google Sheets
Add Google Sheets to a project on the Make platform, initiating its setup in your workflow.
Connect to Google Sheets
Follow the prompts to authorize Make to access your Google Sheets by signing into your Google account.
Set up Google Docs
Integrate Google Docs into the same project on Make to begin its setup.
Connect to Google Docs
Authorize the connection by signing into your Google account, allowing Make to access Google Docs.
Maximize efficiency: integrate Google Sheets with Google Docs benefits
Discover the powerful benefits of integrating Google Sheets and Google Docs: automate document creation, organize workflows, improve collaboration, and ensure data accuracy with ease.
Automatically generate Google Docs based on new entries in Google Sheets, saving time and reducing manual errors.
Improve workflows by updating Google Docs with data from Google Sheets, ensuring accurate and up-to-date documentation.
Consolidate and organize information from multiple Google Sheets into comprehensive Google Docs for reporting or presentation purposes.
Customize Google Docs with dynamic data from Google Sheets in real-time, enabling relevant document creation.
FAQ
How it works
Traditional no-code iPaaS platforms are linear and non-intuitive. Make allows you to visually create, build, and automate without limits.
Trusted by 200,000+ customers
"Make really helped us to scale our operations, take the friction out of our processes, reduce costs, and relieved our support team. It is difficult to not become a fan."
"Make drives unprecedented efficiency within our business in ways we never imagined. It’s having an extra employee (or 10) for a fraction of the cost."
"The simplicity, flexibility and ability to build real complex automations without any knowledge of programming makes it the best thing since sliced bread."
"True citizen development in the entire company. Make is present in every department, empowering the company to offer a unique customer experience."
