Connect Google Sheets and Google Drive integrations
Revolutionize your workflow with Make by seamlessly integrating Google Sheets and Google Drive, automating updates, backups, and reports to keep your data organized and your productivity soaring.
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.
Makes a copy of an existing file.
Creates a new file or folder shortcut.
Creates a file from a text plain.
Creates a new folder.
Creates a new shared drive.
Permanently deletes a file or folder owned by the user without moving it to the trash.Â
Deletes a file's revision.
Deletes a shared drive without any content.
Downloads a file.
Retrieves a file or folder path for an ID.
Gets a specified file's revision.
Gets a shared drive's metadata by ID.
Gets a share link for file or folder.
Performs an arbitrary authorized API call.
Moves a file or folder to a different location in Google Drive.
Moves a file or folder to trash.
Renames an existing folder.
Revokes a file or folder access.
Updates a file's metadata and/or content.
Updates an exisitng file or folder access.
Updates an existing file's revision.
Updates an existing shared drive. For admins only.
Uploads a new file.
Retrieves a folder ID for a folder path.
Retrieves a list of file's revisions.
Searches for files or folders based on search criteria.
Searches for Google Shared Drives with query options.
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 Drive integrations.
Integrate Google Drive and Google Sheets using Make to revolutionize your workflow and productivity. Set up automatic transfers from Google Drive to Google Sheets, ensuring your files are always up-to-date and organized. By syncing your Google Drive directly with your documents in Google Sheets, you can automate backups and create a streamlined, error-free data management system. Use Google Drive as a trigger to update records or generate reports seamlessly in Google Sheets. Experience the transformative power of automation and see how effortlessly you can integrate Google Drive and Google Sheets to elevate your business operations.
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.
Makes a copy of an existing file.
Popular Google Sheets and Google Drive workflows.
Unlock the potential of Google Sheets & Google Drive: automate tasks, enhance collaboration, and increase efficiency with Make.
Create Canva designs with data from Google Sheets and upload to Google Drive
Easily design in Canva using data from Google Sheets, then upload your creations to Google Drive. Boost your workflow with this integrated approach.
TRY IT ->Upload new videos to YouTube and LinkedIn automatically
Enhance your online presence by seamlessly uploading fresh video content to YouTube and LinkedIn. Engage audiences and boost visibility with automated uploads, ensuring your latest videos reach your followers promptly and effectively.
TRY IT ->Monitor Google Drive folder for new files and analyze images with ChatGPT, then add results to Google Sheets
Monitor a Google Drive folder for new files, analyze images with ChatGPT, and log results in Google Sheets for streamlined data management.
TRY IT ->Create transcriptions and update Google Sheets with files from Google Drive
Get your Google Drive files transcribes and update Google Sheets with the transcriptions. Streamline data management using Google Drive, ChatGPT, and Google Sheets.
TRY IT ->Convert Google Sheets rows to audio files using Eleven Labs and upload to Google Drive
Easily convert new Google Sheets rows into audio files with Eleven Labs and upload them to Google Drive for easy access and sharing.
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 ->Detect text from Google Drive files and add structured data to Google Sheets using ChatGPT
Use this template to extract text from Google Drive files and convert it into structured data in Google Sheets using Google Cloud Vision and ChatGPT then update your sheet with the information.
TRY IT ->Generate images with Perplexity AI and ChatGPT and track updates in Google Sheets
Use AI to generate images with Perplexity AI and ChatGPT, store in Google Drive and track updates in Google Sheets. Ideal for creative projects requiring real-time data monitoring and visual content creation.
TRY IT ->Monitor Google Drive folder for new files and analyze images with ChatGPT, then add results to Google Sheets
Monitor Google Drive for new files, analyze images with ChatGPT, and log results in Google Sheets for streamlined data management.
TRY IT ->
How to setup Google Sheets and Google Drive in 5 easy steps
Log in to Make
Start by logging into your Make account.
Connect Google Sheets
Add a Google Sheets module to your Make scenario and authenticate your Google account.
Connect Google Drive
Add a Google Drive module to your Make scenario and authenticate your Google account.
Grant Permissions
Follow the on-screen prompts to grant permissions for the Google services.
Edit Your Scenario
Once connected, you can customize your scenario by adding more Google Drive modules.
Enhance Efficiency and Collaboration by Integrating Google Sheets and Google Drive
By integrating Google Sheets and Google Drive, automate data collection, streamline document management, enhance team collaboration, boost workflow efficiency, and unlock advanced functionalities.
Automatically populate Google Sheets with data from files stored in Google Drive, enhancing data organization and accessibility.
Easily save and organize attachments from Google Sheets entries into Google Drive for centralized storage and retrieval.
Facilitate team collaboration by synchronizing updates made on Google Sheets with files in Google Drive, ensuring everyone has access to the latest information.
Reduce repetitive tasks by automating processes such as saving email attachments directly to Google Drive and logging details in Google Sheets.
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."
"I can't count the number of hours I've saved by using Make. Every single day is simpler because of Make's automation."
