Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
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!
Hi Builders, You’ve been asking versions of the same question in this community: when do I use Smart Assist, when an automation, when MCP, and when plain API code? 🤔 So we’re starting a new series, the Smartsheet Builders Series: Building with Smartsheet MCP and Agents, and the first post tackles exactly that. 📖 Smart…
Tell us the one Smartsheet API that would save you the most manual work or workarounds. One word is enough. If you’d like, add what you’re trying to do and how you handle it today. Your answers go straight into deciding what we build next.
Restructuring sheets with tighter dropdowns and clearer naming is key. Why? Because ambiguous column names and free-text status fields that a person reads as fine can produce inconsistent agent behaviour. It’s worth unpacking, because the reason is not that the agent is worse at reading than you are. It is that you bring…
