Create and Manage Google Sheets
Connect a spreadsheet, define columns, map approved Wemblo fields and test row creation or updates.
Overview
Search Aliases: export to Google Sheets, append row, spreadsheet sync, Wemblo sheet
MAIN CONCEPTS
| Item | Details |
|---|---|
| Spreadsheet | Google file containing one or more sheets/tabs. |
| Spreadsheet ID | Identifier in the Google Sheets URL and API. |
| Sheet / Tab | Individual worksheet inside the file. |
| Column Mapping | Connects Wemblo fields with spreadsheet columns. |
| Append | Adds a new row. |
| Update | Changes an existing row where supported. |
CREATE OR CONNECT A SHEET
- Connect the Google account.
- Open Google Sheet Manage.
- Choose Add New Sheet or select an existing approved spreadsheet.
- Enter a clear name.
- Select the sheet/tab.
- Define column headings.
- Map Wemblo fields.
- Save.
- Send a fictional test record.
- Confirm the row and values in Google Sheets.
- Test duplicate or update behavior.
ACCESS RULES
Use a business-controlled spreadsheet. Share it only with authorized people. Avoid storing passwords, tokens, complete payment details, highly sensitive health information or identity documents. Treat a Sheet as a separate copy that needs its own retention and deletion controls.
COMMON ISSUES & SOLUTIONS
| Item | Details |
|---|---|
| Spreadsheet is not listed | Check Google account and Drive permission. |
| Column value is blank | Review mapping and source field. |
| Duplicate row | Review event retries and external ID. |
| Sheet changed and mapping broke | Update Wemblo mapping after column changes. |
OFFICIAL LINK
https://developers.google.com/workspace/sheets/api/guides/concepts
Last reviewed: