How do I send transaction information from Square to GSheets via Zapier without affecting the formulas I have preset in certain columns of my spreadsheet?
The zap is basically just taking customer name, purchase quantity, total amount paid, and the date (with a reformatter) and sending it to a new row in a tab of my spreadsheet.
Then in that same row, I have a few columns (where the zap isn’t sending any information to) that already have preset formulas to do things like calculate my net pay per transaction, adding customer information from a different tab to the row, etc.
I don’t want Zapier to do anything to these rows, just let the formulas do their work after it submits the information I’m asking it to from Square. But for some reason when Zap sends the information to the sheet, it’s removing the formulas from these columns, causing them to remain blank.
So the automation is working perfectly fine, besides removing the formulas from my spreadsheet that I already have there. Is there a way to send this data without affecting the formulas?
Here’s a breakdown of my Zap steps:
- Trigger: New order in Square (when order status is completed)
- Format date/time to correct format
- Create spreadsheet row to Google Sheets (adding data to the following columns: client name, payment date, gross payment, payment type, and total sessions purchased)
I have formulas preset in the following columns in GSheets that I don’t want Zapier to do anything to, just leave the formulas there so they can autofill once the initial data is added by Zapier:
And Current Pay System:
Does anybody know how I can set up this Zap to send the data I’m asking to without affecting the formulas I already have set up for these columns? Again, the automation is sending the data I’m asking it to correctly… It’s just deleting the formulas in the process, causing the autofill not to function.
I appreciate your help. Thank you so much!
Best answer by christina.dView original