Automatic reports in Google Sheets
The sheet stays where you already work — it just fills itself in. No scripts, no macros, no weekly export by hand.
What can go into the sheet
- Every order with its traffic source, for attribution.
- Daily or weekly stock with days-of-cover worked out.
- Enquiries from forms on your site.
- Any scenario result that reads better as a table than as a chat message.
How to connect it
- Create a sheet
One spreadsheet with column headers in the first row is enough.
- Share it with a service account
You grant access to that one sheet, not to your whole drive.
- Enter the key in Oxta
Once, encrypted, never shown in run history.
Why this beats a macro
A script inside the spreadsheet breaks silently: you see an empty tab and cannot tell when it stopped filling.
Here every write is a run with a history: what arrived, what was written, what was not and why. A rejected write is visible immediately, not at the end of the month.
The essentials, briefly
Do I have to pay Google?
No, an ordinary Google Sheet is enough. Size limits are Google’s own.
Can it append rows and update existing ones?
Yes — those are two different steps: append a row, or find and update one.
What if someone rearranges the columns?
Oxta notices that an expected column is gone and warns you instead of writing data into the wrong ones.