Send email from Google Sheets in Google Sheets
This is a safe email-draft fixture. In C2, enter exactly "The weekly report is ready." and in D2 enter exactly "Draft". Do not send an email, open Gmail, or edit the existing finance draft.
Verified by JosephineAbout 60 secondsThis is a safe email-draft fixture. In C2, enter exactly "The weekly report is ready." and in D2 enter exactly "Draft". Do not send an email, open Gmail, or edit the existing finance draft.
Step-by-step
Select the targetThis is a safe email-draft fixture.
Apply the changeIn C2, enter exactly "The weekly report is ready." and in D2 enter exactly "Draft".
Shortcut or faster method
Select the target cell, type or paste the formula in the formula bar, then press Enter.
Expected result
The weekly report email is saved as a draft row and no message is sent.
Common mistake
Applying the change to more rows, columns, or cells than the task specifies.
Troubleshooting
Re-select C2 and repeat the final action. The weekly report email is saved as a draft row and no message is sent.
Example spreadsheet data
This is the clean fixture used for the verified run.
| Recipient | Subject | Draft body | State |
| ops@example.com | Weekly report | ||
| finance@example.com | Invoice review | Please review invoice 1042. | Draft |
Video transcript
- Open the prepared Email draft spreadsheet.
- Select the target. This is a safe email-draft fixture.
- Apply the change. In C2, enter exactly "The weekly report is ready." and in D2 enter exactly "Draft".
- The weekly report email is saved as a draft row and no message is sent.