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.
Connect any app with Google Sheets and Google Drive
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 ->Extract text from Google Drive image / pdf, translate and extract entities from text
Use this template to extract Text from images and PDF (OCR) then Translate text and Extract named entities. Created by [email protected]
TRY IT ->Generate voice overs with ElevenLabs from WordPress articles and upload links to a Google Sheet
Create high-quality voice overs easily using ElevenLabs from WordPress articles; streamline the process by uploading links directly to a Google Sheet for enhanced content management.
TRY IT ->Performance Management - Reminder and Individual Performance Generation 2/3
In the second scenario, reminders are sent for those team members whose reviews have not been completed yet. For those reviews that have been completed, a report with a visual chart are created and sent to the manager on Slack. This template works with this Google Doc template: https://docs.google.com/document/d/1wf0N0KfWqnsDgI96MYfpxBZpC--cVh9NVYdaju-N3as/edit?usp=sharing and this QuickChart: https://quickchart.io/chart/render/zm-6ac62add-a5e2-49aa-93ee-f3138962e196
TRY IT ->Performance Management - Team Performance Generation 3/3
The third scenario compiles the team's overall rating graph, the team’s comparative KPI ratings graph, and the individual KPI ratings graphs. Please use the Google Docs template for this scenario to work correctly. https://docs.google.com/document/d/1jSVNxntn261zk0Zb05BcRJHI_1S8EVJAxU5qvi9WGos/edit?usp=sharing
TRY IT ->Transcribe audio file and analyze sentiment with Eden AI PART 1
Use this template to transcript audio data from Google Drive into Eden AI Speech-to-text module. Then extract sentiment from text transcripted. Datastore module is used to wait until the transcription is finished. Please see Speech-to-text + Sentiment Analysis PART 2 template. Created by [email protected]
TRY IT ->Save Gmail emails and attachments to Google Sheets and Google Drive
Use this template to save a Gmail message to your Google Sheets spreadsheet as a new row and its attachments to Google Drive.
TRY IT ->Create a post in Instagram for new Google sheets rows
Every time a new row is added to your Google Sheets spreadsheet, Make will automatically create a photo post to Instagram from a file from Google Drive. The template uses this [example spreadsheet](https://docs.google.com/spreadsheets/d/1Z3puHSSMlTHnWMK3CUGGyuKA-zJkFoKnFdb2w7UvGVg/edit?usp=sharing).
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 500,000+ Makers
"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."