Hi,
I’d like to use Zapier to add financial account balances for multiple accounts to a Google sheet on a daily basis.
I can get the balances using a GET in Webhooks.
I can add a new column for my sheet using the “Create Spreadsheet Column” Zap with today’s date.
I can’t work out how to add the balance to the new column?
Here’s what my spreadsheet looks like with sample data:
So on a daily basis I’d like to add today’s date to E1 and then account balances to E2, E3, E4.
Any suggestions? Thanks for any help!