# How to send email of google sheet that has been created in the same scenario
**URL:** https://community.make.com/t/how-to-send-email-of-google-sheet-that-has-been-created-in-the-same-scenario/34557
**Category:** Questions
**Tags:** connections, google-sheets, webhooks
**Created:** [April 21, 2024, 2:51pm UTC](https://community.make.com/t/how-to-send-email-of-google-sheet-that-has-been-created-in-the-same-scenario/34557 "2024-04-21T14:51:40Z")
**Posts on this page:** 5
**Page:** 1
### Author:  [@Tom2504](https://community.make.com/u/Tom2504)
#### Post date: [April 21, 2024, 2:51pm UTC](https://community.make.com/t/how-to-send-email-of-google-sheet-that-has-been-created-in-the-same-scenario/34557/1 "2024-04-21T14:51:40Z")
Hello,
I am trying to use Make to generate a client insight report, and then send in the same scenario, by using google sheets and gmail. The system creates a new google sheet, but I cannot seem to find a way to link this sheet to the email, as the several module add different sections to the sheet, no one module of the workflow contains all of the sheet information. Google sheets generates a new URL for the newly created sheet also. Any advice would be greatly appreciated.
For reference, When selecting ‘content’ or ‘attachments’ for the email, the only things I can include from the new sheet are {{100.sheetId}}{{100.title}}{{100.index}}{{100.sheetType}}{{100.gridProperties}}{{100.gridProperties.rowCount}}{{100.gridProperties.columnCount}}{{100.gridProperties.hideGridlines}}, not the sheet itself, or its URL
---
### Author:  [@Donald\_Mitchell](https://community.make.com/u/Donald_Mitchell)
#### Post date: [April 21, 2024, 3:01pm UTC](https://community.make.com/t/how-to-send-email-of-google-sheet-that-has-been-created-in-the-same-scenario/34557/3 "2024-04-21T15:01:32Z")
Hello @Tom2504,
Using the Document ID returned by the Sheets module, you could probably use the Google Drive module to download the sheet (optionally, as an XLSX file), then attach that to the email.
---
### Author:  [@samliew](https://community.make.com/u/samliew)
#### Post date: [April 21, 2024, 3:43pm UTC](https://community.make.com/t/how-to-send-email-of-google-sheet-that-has-been-created-in-the-same-scenario/34557/4 "2024-04-21T15:43:26Z")
Welcome to the Make community!
You can use the Google Drive “Get a Share Link” module to get the share link of the document using the spreadsheet ID, if the URL is what you want to share in the email.
---
### Author:  [@Tom2504](https://community.make.com/u/Tom2504)
#### Post date: [April 22, 2024, 9:36am UTC](https://community.make.com/t/how-to-send-email-of-google-sheet-that-has-been-created-in-the-same-scenario/34557/5 "2024-04-22T09:36:49Z")
Thank you both very much, all is fixed now!
---
### Author:  [@Make\_Bot](https://community.make.com/u/Make_Bot)
#### Post date: [May 6, 2024, 1:34pm UTC](https://community.make.com/t/how-to-send-email-of-google-sheet-that-has-been-created-in-the-same-scenario/34557/6 "2024-05-06T13:34:02Z")