Made a quick walk-through of how we used RPA to extract and transform data, loaded it into an Excel file and then used that as the datasource for a Glide app.
We did this because the data we needed to use was in an aged-care industry CRM that has a limited API and isn’t integrated with Zapier etc. So we couldn’t use the usual no-code automation tools.
This approach is awesome because you get the power of RPA in the back end and the simplicity of Glide in the front end.
Plus we can keep the Excel file in the client’s infrastructure (most big orgs use Microsoft’s stack so this suits their IT and security requirements).