Google Drive and Google Sheets
Last updated
Was this helpful?
Last updated
Was this helpful?
Mechanic provides powerful integration with Google Drive and Google Sheets, allowing you to automate file management and spreadsheet operations.
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
The Google Drive action allows you to upload and manage files in Google Drive. See in-depth documentation of the Google Drive action .
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)
The Google Sheets action enables interaction with spreadsheets, including creation and data manipulation.
create_spreadsheet
: Create new spreadsheets
append_rows
: Add data to existing spreadsheets
export_spreadsheet
: Export spreadsheets in various formats
Text files
PDFs (generated from HTML)
CSV files
HTML files
Any binary file format
XLSX (Excel)
CSV
HTML
ODS
TSV
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
See in-depth documentation of the Google Sheets action .