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.