Sign in to join the conversation:
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!
Is anyone having issues with the add row API function? Seems to be hindering for about an hour now on my end.
Has any utilized API to make changes to employees allocation percentage. I am developing a script that will recognize employees across multiple projects. When it see's that they have overlapping projects it will automatically balance out their timelines. Example Dylan McCord is overallocated on 2026-02-02–2026-03-02 TRs…
Over the past few weeks, I’ve been building an internal Admin Governance & Automation Framework for our Smartsheet environment — focused on visibility, auditability, and operational efficiency. Manual tracking simply doesn’t scale. So, I designed and implemented a modular, API-driven crawler framework that programmatically…
