Placeholders and cell values
Put the date, the spreadsheet name or any cell value into the subject and message.
Type a placeholder by hand or click one of the chips under the message box.
Built-in placeholders
| Placeholder | What it inserts |
|---|---|
{{Spreadsheet Name}} |
The file’s name |
{{Sheet Name}} |
The tab being sent, or “All sheets” |
{{Date}} |
Today’s date in the spreadsheet’s time zone, e.g. 30 Oct 2026 |
{{Time}} |
The time the report was sent, e.g. 09:04 |
{{Spreadsheet URL}} |
A link to the spreadsheet |
Cell values
Any cell can be a placeholder: write the tab name, an exclamation mark and the cell, for example {{Sales!D6}}. The value is inserted as it is displayed in the sheet, so a cell formatted as ₹1,74,000 arrives as ₹1,74,000.
This is handy for a subject line that carries the headline number:
Sales to date: {{Sales!D6}} ({{Date}})
Or a message that summarises before the attachment:
Hi team,
Total units this week: {{Sales!C6}}. Full table attached.
Where placeholders work
Subject and message. Recipients can also be placeholders if a cell holds an email address, for example {{Settings!B2}} in the To field.