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!
When you work with data in a spreadsheet or an AI client, what usually happens before it ends up in Smartsheet? Pick the closest one, and tell us how it really goes if it’s messier than the choices. It usually is. I copy and paste it over by hand I export a file and import it I clean it up in a spreadsheet first, then move…
At ENGAGE 2026, five customers showed what they’ve actually built with AI on top of Smartsheet. No roadmap slides, just working setups. Here’s the short version: Lilly Kinsale: One live changeover view, built with Claude. It saves roughly 30-35 minutes per core team member every day. Swampfox: AI proposes RAID log updates,…
I’m looking to use Linked Dropdown Columns within a CC blueprint template My setup is that each provisioned project gets its own workspace containing: Project Plan Team Roster I want a dropdown column in the Project Plan to be linked to specific column in that same project's Team Roster. For example: Project A Project Plan…
