Google Sheets Connector

01. Overview

• Plugin Name: Google Sheets Connector
• Category: Spreadsheet / Data Integration
• Authentication: Managed by Mekari Platform

02. Key Features

• Connect to Google Sheets using Service Account authentication
• Read data from specific sheet ranges
• Write and insert data using structured payloads
• Support multiple rows and columns in a single request
• Simple and secure configuration
• Ideal for automation and reporting workflows

03. Supported Use Cases

• Automated reporting
• Data synchronization between systems
• Logging workflow results to spreadsheets
• Operational tracking and monitoring
• Lightweight data storage for workflows

04. Authentication Configuration

Authentication is configured via request header using a Google Service Account.

05. Important Notes

• The service account must have Editor access to the spreadsheet
• Sheet names are case-sensitive
• The sheet structure (columns and headers) must already exist
• Data is written in the order provided in the values array

06. Security Considerations

• Store service account credentials securely
• Do not expose private keys in client-side applications
• Limit spreadsheet access to required service accounts only

07. Compatibility

• Compatible with standard Google Sheets
• Works with Google Workspace and personal Google accounts (with proper sharing)
• Uses Google Sheets API

08. Troubleshooting

• Permission denied: Verify the service account is shared on the spreadsheet
• Invalid range: Ensure the sheet name and cell range exist
• Authentication failed: Check service account JSON format

09. Summary

The Google Sheets Connector Plugin enables secure and flexible integration between Officeless workflows and Google Sheets, allowing teams to automate spreadsheet-based processes with ease.