I want to export a Glide to using Make webhook. How can I do this?
Do you mean a trigger from Make would tell Glide to export all its data, or do you want to send a table of data from Glide to Make?
I want to click a button in Glide and send the table data to Make then to SharePoint
I think you can export it as a CSV, then send the link to Make to upload the CSV to SharePoint.
Yes, I have done that already. However, because I need to send this securely without having the CSV file accessible by anyone that has the link, I want to send everything securely and encrypted through Make.
Glide CSV files are not secure and on top of that the link is publicly accessible by anyone that gets access to the link without restriction.
I haven’t tried, but can the CSV action write to a user-specific column? That will be a bit more secured, at least you know that if the link is shared anywhere, you can point to a specific user who “holds” the link in their data.
You could delete the link from Glide after you are done, although it could take up to 30 days after that before it’s removed from Glide storage.
I can think of two alternatives:
- If you have Business Plan or better, use the API.
- Otherwise, do it the “old fashioned” way. That is, generate a CSV export using templates and joined lists, and send that via a webhook. Doing it that way, no URL is generated. You’d just be sending the raw CSV.
2 Likes
Thank you @Darren_Murphy. Could you share with me some instructions on how to do these? I do have the Business plan but I need to watch how much updates this will cost, as users will be exporting data frequently.
I think no one update during export to CSV by template column.
And no one update by triggering webhook, but one update by call API (on business plan)
Update: as folks mentioned one update per triggering webhook.
Does the final SharePoint link have to be shared back to them?
Regardless, you would need a trigger webhook action, which I believe costs 1 update per run. It does show up in my usage board.
@slscustom.ru, Exporting CSV uses 3 updates. See attached screenshot. Webhook uses 1 and API call uses 1.
@ThinhDinh, I plan on using Make to send the link to the user via email with an expiration date for security reasons.
As Darren_Murphy suggested not csv action but template column to csv
I need some instruction on how to do this. Can you help?
It is better to wait for Darren’s version i believe it will be clear, powerful, and easy to understand.
All i can say is just repeat: you just need some joint lists combined to template column and to send result (raw csv data) to Make which can convert it to file.
May be this How To: CSV Export and send as email
Another trick Export Glide Table/ Google Sheet Data to CSV using Joined List & Apps Script
1 Like
I believe this will do what I need it to do. I will give it a go. Thank you.
1 Like
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.