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:
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/e76133d0-3319-48d7-a878-e5ec24f67745.png)
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!