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.