Google Workspace connector tools

(Optional) conferenceData – Conference data for video meetings (for example, Google Meet). Example:

{
  "createRequest": {
    "requestId": "unique-id-123",
    "conferenceSolutionKey": {
      "type": "hangoutsMeet"
    }
  }
}

(Optional) reminders – Reminder settings with useDefault (boolean) and optional overrides array. If useDefault is true, calendar default reminders apply. If useDefault is false, specify custom reminders in overrides array. Example:

 {
  "useDefault": false,
  "overrides": [
    {
      "method": "email",
      "minutes": 60
    },
    {
      "method": "popup",
      "minutes": 10
    }
  ]
}

• Valid methods – email, popup, and sms.
• Minutes range – 0–40320 (four weeks).

• For bold only – bold.
• For bold and red – bold,foregroundColor.
• For italic and underline – italic,underline.
• For font size – fontSize.

• {
    "bold": true,
    "foregroundColor": {
      "color": {
        "rgbColor": {
          "red": 1.0,
          "green": 0.0,
          "blue": 0.0
        }
      }
    }
  }

• Common styles:
  • Bold – {"bold": true}
  • Italic – {"italic": true}
  • Underline – {"underline": true}
  • Red text –

  • {
    "foregroundColor": {
      "color": {
        "rgbColor": {
          "red": 1.0, 
          "green": 0.0, 
          "blue": 0.0
          }
        }
      }
    }

  • Font size 14pt – {"fontSize": {"magnitude": 14, "unit": "PT"}}

• 10 – Default.
• 50 – For larger lists.
• 100 – Maximum recommended.

• Single cell – Sheet1!A1
• Rectangular range – Sheet1!A1:D10
• Entire row – Sheet1!5:5
• Entire column – Sheet1!A:A
• Multiple columns – Sheet1!A:C
• Named range – MyNamedRange
• Default sheet – A1:D10 (uses first sheet)

• FORMATTED_STRING – (Default) Returns formatted date text (for example, "11/15/2024").
• SERIAL_NUMBER – Returns numeric date value (for example, 45249).

• FORMATTED_VALUE – (Default) Returns formatted text as displayed in the UI.
• UNFORMATTED_VALUE – Returns underlying values (for example, numbers without currency formatting).
• FORMULA – Returns formulas as text (for example, =SUM(A1:A10)).

• All columns – Sheet1!A:D (appends to columns A through D).
• Full sheet – Sheet1!A:Z (appends across many columns).
• Specific columns – Sheet1!B:E (appends to columns B through E).
• Named range – DataTable (appends to named range).
  
  Use column ranges (A:D) instead of cell ranges (A1:D100).

• Single row – John [Doe|john@example.com](mailto:Doe|john@example.com)|Active.
• Two rows – John [Doe|john@example.com](mailto:Doe|john@example.com)|Active\nJane [Smith|jane@example.com](mailto:Smith|jane@example.com)|Pending.
• With date and status (three rows) – [John|john@example.com](mailto:John|john@example.com)|[2024-11-12|Active\nJane|jane@example.com](mailto:2024-11-12|Active\nJane|jane@example.com)|[2024-11-12|Pending\nBob|bob@example.com](mailto:2024-11-12|Pending\nBob|bob@example.com)|2024-11-13|Active.
• With empty cells – [Alice||alice@example.com](mailto:Alice||alice@example.com)\[nBob|Smith|bob@example.com](mailto:nBob|Smith|bob@example.com) (Alice has no last name).

• INSERT_ROWS (default) – Adds new rows after existing data.
• OVERWRITE – Overwrites cells starting at append position.

• USER_ENTERED (default) – Parses input, such as formulas, numbers, and dates.
  • "2024-11-12" becomes a date, "100" becomes number 100.
• RAW – Stores as-is. Everything becomes text.
  • "2024-11-12" stays as text, "100" becomes text "100".

• Specific range – Sheet1!A1:D10
• Entire row – Sheet1!5:5
• Multiple rows – Sheet1!2:5
• Entire column – Sheet1!A:A
• Multiple columns – Sheet1!A:C
• Entire sheet – Sheet1!A:Z (adjust Z based on sheet width).

• Simple table (3x3) – [Name|Email|Status\nJohn|john@example.com](mailto:Name|Email|Status\nJohn|john@example.com)|[Active\nJane|jane@example.com](mailto:Active\nJane|jane@example.com)|Inactive.
• With headers only – Product|Price|Quantity.
• Coupon codes table – Code|Discount|Valid Until\nSAVE10|10%|2024-12-31\nWELCOME20|20%|2024-11-30.
• With empty cells – [Name|Phone|Email\nJohn||john@example.com](mailto:Name|Phone|Email\nJohn||john@example.com)\nJane|555-1234 (John has no phone, Jane has no email).

• Single range update – Sheet1!A1:B2::[Name|Email\nJohn|john@example.com](mailto:Name|Email\nJohn|john@example.com)
• Two range updates (different sheets) – Sheet1!A1:B2::[Name|Email\nJohn|john@example.com](mailto:Name|Email\nJohn|john@example.com)\n\nSheet2!A1:C1::Q1|Q2|Q3
• Three range updates – Sheet1!A1::Status\n\nSheet1!B1:C1::100|200\n\nSheet2!A1:A3::Red\nGreen\nBlue
• Update header and data rows – Sheet1!A1:C1::Name|Email|Status\n\nSheet1!A2:C3::[John|john@example.com](mailto:John|john@example.com)|[Active\nJane|jane@example.com](mailto:Active\nJane|jane@example.com)|Pending
• Different sheets, different sizes – Summary!A1::Total Sales\n\nData!A1:D2::Q1|Q2|Q3|Q4\n100|200|300|400

• USER_ENTERED (default) – Parses input, such as formulas, numbers, and dates.
  • "2024-11-12" becomes a date, "100" becomes number 100.
• RAW – Stores as-is. Everything becomes text.
  • "2024-11-12" stays as text, "100" becomes text "100".

• To format only column A – endColumnIndex = 1
• To format columns A–E – endColumnIndex = 5
• To format columns A–Z – endColumnIndex = 26

• To format only row 0 – endRowIndex = 1
• To format rows 0–4 (first 5 rows) – endRowIndex = 5
• To format rows 0–9 (first 10 rows) – endRowIndex = 10

• Column A – 0
• Column B – 1
• Column C – 2
• Column D – 3, and so on.

• First row – 0
• Second row – 1
• Tenth row – 9

• Red – 1.0,0.0,0.0
• Green – 0.0,1.0,0.0
• Blue – 0.0,0.0,1.0
• Yellow – 1.0,1.0,0.0
• Orange – 1.0,0.65,0.0
• Light Blue – 0.68,0.85,0.90
• Light Gray – 0.85,0.85,0.85
• Dark Blue – 0.0,0.0,0.55
• White – 1.0,1.0,1.0
• Black – 0.0,0.0,0.0

• Black text – 0.0,0.0,0.0
• White text – 1.0,1.0,1.0
• Red text – 1.0,0.0,0.0
• Blue text – 0.0,0.0,1.0
• Gray text – 0.5,0.5,0.5

• true – Exact case-sensitive match only
• false (default) – Fuzzy search that finds presentations containing the search term

•  CENTER_INSIDE – Fit within bounds.
•  CENTER_CROP – Fill bounds.

• 0 – Move to beginning.
• 1 – Move to second position.
• 10 – Move to 11th position.
• 20 – Move to end of a 20-slide presentation.