Google

Mechanic provides powerful integration with the Google APIs, including Google Drive, Sheets and Docs, allowing you to automate file management, spreadsheet operations, and more. Using the Google action is more complex than using the Google Drive and Google Sheetsaction, but the advantage is that it allows use to use any of the features in the Google Drive, Sheets, and Docs REST API.

Supported APIs

• Google Docs

• Google Drive

• Google Sheets

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:

1. Go to Settings → Authentication in Mechanic

2. Select Google in the provider list

3. Connect your Google account

4. Grant the necessary permissions to Mechanic when prompted (there will likely be multiple prompts)

Google Integration

The Google action allows you to use the Google Drive, Google Docs, and Google Sheets APIs. See in-depth documentation of the Google action here.

Basic Usage

{% action "google" %}
  {
    "account": "[e-mail]",
    "method": "GET",
    "url_path": "/drive/v3/files",
    "headers": {
      "Accept": "application/json"
    },
    "body": {
      "pageSize": 5,
      "fields": "files(id,name,mimeType)"
    }
  }
{% endaction %}

The GET method in the Google action differs slightly from conventional HTTP GET usage, in that parameters may be passed in a body object in lieu of appending a query string to the URL.

If any traditional query string parameters are included in the URL path, then any key-value pairs in the body object will be ignored.

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