Can I integrate a sheet with my bank (Lloyds) to automatically download new statement lines every 30 mins or so. I have to login to my bank and copy the data across all the time and would like to automate it if possible.
Hi Tom,
It mainly depends on your bank. Is it possible to access the data from the bank through an API or similar?
Hope that helps!
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
Thanks for your response Andree. I new to this. What is an API, and how can I tell if they have one?
Happy to help!
They do have an API but I don't know what's possible with it. Do you have any option to email the transactions on a regular basis instead?
More info about the API: https://developer.lloydsbank.com/opendata-v2.2#get-personal-current-accounts-2.2
I hope that helps!
Hi all, I have been using webhooks in my nodejs application for awhile and sometime I think my webhook is not receiving the event callback. In my sheet I have a column A, (not editable directly) which is a formula that's calculated using column B. When an user updates column B, column A gets updated which triggers the…
I've completed the authentication process, created a trigger and made sure that the trigger has the right source sheet and event type but I am noticing that I can't get any data from the trigger. My goal is to get the row information when new row is added in my sheet so I can copy some of the data over to another sheet.…
I am trying to create a new Sheet in a specific Workspace using the Smartsheet SDK for C# and I keep getting an unexpected exception The statement above compiles just fine. The Workspace ID (wkspID in the code) is correct. I can create the Sheet just fine locally but the sheet does not have an ID until it is created in…
