Google Sheets Integration

Lucenero connects Google Sheets once per workspace. After connecting, automations can append rows to a spreadsheet using the google_sheets.append_row action.

Connect Google Sheets

1. Open Sidebar → Settings (/workspaces/:id/settings).
2. Go to Settings → Integrations.
3. Connect Google Sheets and complete the authorization flow.

Use Google Sheets in an automation

1. Open Sidebar → Automations (/workspaces/:id/automations).
2. Create or edit an automation.
3. Add an action: Google Sheets → Append Row (google_sheets.append_row).
4. Paste your Spreadsheet ID.
5. Use Autofill to fetch tabs/columns and map fields.

Troubleshooting

Append row fails

• Confirm the workspace is connected to Google Sheets in Settings.
• Confirm the connected Google account has edit access to the spreadsheet.
• Confirm you pasted the correct Spreadsheet ID (not the full URL if your UI expects only the ID).

Template variables reminder

If you map automation fields into Sheets, use supported tokens like {{title}} or {{username}}. Nested tokens like {{task.title}} are not supported.

Related articles

• Automations Overview
• Automation Troubleshooting