Kapta · 15/09/2026
Choose a unique reference for each operation and decide whether the sheet is for viewing or also editing data. A shared sheet can help your team track work when its rows remain linked to the source system.
What information can reach the sheet?
The Google Sheets API supports reading and writing spreadsheet data. Select useful columns such as reference, date, service, amount, status and document link. Google Sheets API overview.
Should a changed booking create another row?
If the sheet represents current booking status, update the row matching its identifier. Use a separate area for event history. Mixing these models can make an amendment look like a new booking.
Can the team sort and edit the sheet?
Define editable columns and protect fields used by the integration. Match records by identifiers rather than row numbers, which change when the table is sorted. Include sorting followed by a booking update in testing.
How do I request this from Kapta?
Provide the desired columns and a fictional example. Identify who needs access and whether edits should return to the source. Two-way synchronisation requires specific rules for resolving concurrent changes.
