Export Data?

I tried creating an export to excel functionality using google sheets.
Each sheet has a GID, you can find GID of specific sheet in the URL of spreadsheet. Then you can use this link to download specific sheet -
<link_to_google_sheets>/export?format=xlsx&gid=<sheet_id>
sample
KEY is the unique ID of the spreadsheet.
Sample below:
https://docs.google.com/spreadsheets/d/14nA5-DV6_8FwR7Q6c8UY6EPB7YpqooQ8EYy2Tm11Dr8/export?format=xlsx&gid=1863657158
Once you have your export url, you can add action to your button to open link with target as your export url.

P.S - You will have to create user friendly sheets with only required columns for the purpose of export and use the link of that sheet.

5 Likes

Oh wow! Huge thanks for that! :star_struck:

This is fantastic!

How about the PDF? How did you get it to download as a PDF?

You can specify “format=pdf” in the link to generate it.

2 Likes

“format=csv” :heart_eyes:

1 Like

Saw your post late. Yes, you can export in formats supported by Google Sheets.

1 Like

Hi Seemapahelani :pray: :clap:
Thank you so much for this great help!

This is great. Thanks for sharing.!