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!
I tried using the product feedback form but it kept failing so I'm posting here instead. It's possible this is user error but I hope not for my ego's sake :). After the APIs were recently updated, my GET /users API call is only able to return a result of 2000 records in an array per page when I use pageSize as the…
Goal: Power Automate to update SmartSheet Row with "In Revision" Status when selecting "Reject" for my "Wait and Approve" workflow I have a Power Automate approval workflow that is triggered when a Smartsheet row is updated. The approval process works correctly, but I'm trying to handle the Rejected outcome. When an…
Receiving this error every time I try to save a change to a single sheet or access the Automation menu. All other sheets are working correctly. I've tried multiple browsers, clearing my cache, restarting the computer and checking for Smartsheet outages. While I'm actively working on developing the sheet further, there are…
