# Four Google AI workflows: email, Sheets, a handoff app and a persistence test

Give each job the context it needs and check the result where it will actually be used.

[HTML](https://lukejbyrne.com/library/guides/1eekrq468d4/)
Content language: en
Author: Luke Byrne
Video published: 2026-10-23
Sponsored coverage: Coursera

[Watch the video](https://www.youtube.com/watch?v=1EEKrq468D4)
Video language: English

## Draft an email from the complete thread

Thanks to Coursera for sponsoring this video.

The examples use fictional demonstration data. The first job is a reply that respects the existing conversation and does not invent commitments.

1. Give Gemini the complete relevant thread and state the reply’s purpose.
2. List the dates, promises and questions it must preserve.
3. Review the draft against the thread before sending, especially anything that sounds like an agreed deadline or offer.

## Make the spreadsheet actionable

The Sheets example is about identifying ready and blocked projects, not producing a decorative summary.

1. Provide the project table and define the status fields.
2. Ask which items are ready, blocked or missing a necessary input.
3. Check the answer against individual rows and correct ambiguous status definitions before acting on it.

## Build and test the handoff app

Google AI Studio builds an editor handoff app, but publication does not prove that multiple users share the same data.

1. Describe the handoff records, actions and intended users before generating the app.
2. Create a demo record and edit it.
3. Publish a test version, then open a separate browser session and check whether the record and update are present.
4. Resolve the storage and access model before introducing real production information.

## The takeaway

Test the job’s actual requirement: a faithful email, correct rows or data that persists for the intended users. The original description’s demo-file link was unfinished, so no download is promised here.

## Workflow resources

- [imp.i384100.net](https://imp.i384100.net/rE3y7G)
- [imp.i384100.net](https://imp.i384100.net/KBLGQN)

## Chapters

- [0:00 From worker to manager](https://www.youtube.com/watch?v=1EEKrq468D4&t=0s)
- [1:19 The course and the tools](https://www.youtube.com/watch?v=1EEKrq468D4&t=79s)
- [2:06 Set up Gemini](https://www.youtube.com/watch?v=1EEKrq468D4&t=126s)
- [2:45 Draft a useful email reply](https://www.youtube.com/watch?v=1EEKrq468D4&t=165s)
- [4:34 Make your spreadsheet tell you what's ready](https://www.youtube.com/watch?v=1EEKrq468D4&t=274s)
- [6:35 Build a handoff app in Google AI Studio](https://www.youtube.com/watch?v=1EEKrq468D4&t=395s)
- [9:28 Publish the app and test shared access](https://www.youtube.com/watch?v=1EEKrq468D4&t=568s)
- [11:10 What each job needs](https://www.youtube.com/watch?v=1EEKrq468D4&t=670s)

## Sources and limitations

Written follow-along guide prepared 31 October 2026 from this exact published video’s description and chapter sequence. The checklists are editorial adaptations, not verbatim transcript quotations. Demonstrated results are attributed to the video; the full final video was not independently transcribed or watched for this article, and the product was not retested. For installation commands, later interface changes and current offers, use the original resources linked here.

[Original video](https://www.youtube.com/watch?v=1EEKrq468D4)