Google Drive and Google Sheets
Mechanic provides powerful integration with Google Drive and Google Sheets, allowing you to automate file management and spreadsheet operations.
Authentication
You can connect more than one Google account choosing which account to use when writing your task code.
Before using Google integrations connect your Google accounts:
Go to your Mechanic Settings screen
Click on Authentication
Connect your Google account
Grant the necessary permissions when prompted
Google Drive Integration
The Google Drive action allows you to upload and manage files in Google Drive. See in-depth documentation of the Google Drive action here.
Basic Usage
Supported Features
Upload multiple files in a single action
Paths can include folders (e.g., 'reports/monthly/file.txt')
Overwrite existing files (optional)
Generate various file types (text, PDF, CSV, HTML)
Google Sheets Integration
The Google Sheets action enables interaction with spreadsheets, including creation and data manipulation.
See in-depth documentation of the Google Sheets action here.
Basic Usage
Supported Operations
create_spreadsheet
: Create new spreadsheetsappend_rows
: Add data to existing spreadsheetsexport_spreadsheet
: Export spreadsheets in various formats
File Type Support
Drive Upload Formats
Text files
PDFs (generated from HTML)
CSV files
HTML files
Any binary file format
Sheets Export Formats
XLSX (Excel)
CSV
PDF
HTML
ODS
TSV
Permissions
The integration requires the https://www.googleapis.com/auth/drive.file
scope, which allows:
Access to files created by the app
Access to files explicitly shared with the app
No access to other files in your Google Drive
Last updated