Blog Workflow Automation Guides
Prepare Google Slides from Google Sheets
Give a Midpoint worker your approved Google Sheet and Slides template. Get a checked draft deck, source links and clear questions about unfinished figures.

A monthly warehouse review needs four slides: the reporting month and sites, shipment volume, on-time dispatch and cost per order. The director needs to know which figures are ready for the meeting and which still need an answer.
Priya runs operations for a regional warehouse network. She can hand the preparation to a Midpoint worker, along with the approved Google Sheet for the month just closed and her Google Slides template. The worker copies the template, fills in the four slides and checks what each one actually shows against its source.
What comes back is a draft copy of the deck, with a source link beside each figure and two precise questions holding up the slides that aren't finished. The shipment total is checked. The dispatch period and a missing cost need Priya's answer. The worker hasn't presented anything or guessed why a number moved.
Slide 1: October, with the right warehouses
The cover slide sets the scope for the rest of the deck: October 1 to 31, with the warehouses Priya chose. It should match the version of the sheet that finance and the site leads approved, not a live tab that has already moved on to November.
The worker names the copy “October warehouse review, draft” and leaves the original template unchanged. It checks the title and reporting dates before moving on. An old September heading above an October chart would make the whole presentation harder to trust.
Copying the template first is also how Google's own developer guide approaches filling a presentation with spreadsheet data. If filling a template that way already gives you the deck you need, use it. Priya wants the checking handed over as well.
Slide 2: 48,210 shipments, checked
The volume slide shows 48,210 shipments. The approved October total is 48,210. The chart includes Priya's warehouses and every October date.
The worker checks the finished slide, not just the cell it copied. The number has to be readable, the heading has to say October, and the axis has to be in shipments. A cropped last digit or a chart range that reaches into November would change what the room sees.
Beside the chart, a source link opens the October total in the sheet, so Priya can go straight from the slide to the numbers behind it.
Google already supports linked charts and tables, with Update and Update all buttons. The Slides API can also add and refresh linked Sheets charts. If your charts keep the same shape every month and your sheet is reliable, that may be all you need. Here the worker checks the range, updates the linked chart in the copy and reads the slide that results, labels included.
Slide 3: the dispatch period is too short
The Dispatch tab shows 94.2%, but its export only covers October 1 to 28. The slide reports the whole month, and an approved sheet doesn't change that: 28 days isn't October.
The worker leaves the slide's monthly figure open. Beside the source link, its note reads:
October on-time dispatch needs a full-month figure. The source shows 94.2% for October 1 to 28. Should the slide show that shorter period explicitly, or should the site lead provide an export through October 31?
Priya can accept the shorter period with the dates clearly shown, or get the complete export. The worker doesn't estimate the missing three days, average the partial rate with another tab or explain why dispatch changed.
Once Priya answers, the worker updates slide 3 and checks the dates, the percentage and what counts as on time in the source she picked.
Slide 4: cost per order still needs a figure
The sheet calculates $3.87 per order, but the October carrier surcharge row is empty. A blank isn't the same as zero. Putting $3.87 on the slide as the final monthly cost would hide the question.
The worker leaves slide 4 open too, with this note linked to the cost cell, the order count and the empty surcharge row:
The sheet currently calculates $3.87 per order. October carrier surcharges are unconfirmed. Please confirm whether the row is zero or still awaiting a figure before this becomes the monthly cost per order.
The note quotes the sheet's own $3.87. The worker doesn't work out a cost of its own. Once the surcharges are confirmed, it updates slide 4 and checks the currency, the rounding and the final amount.
The deck comes back before the meeting
Priya opens a draft with a checked shipment slide and open questions on slides 3 and 4. Each source note sits beside its figure, so she can read the deck in order instead of matching it against a separate report.
The worker leaves the approved sheet and the original template alone. It doesn't add its own commentary, share the deck or present it. Priya decides who sees it: anyone who can open the deck can see its linked charts and tables, even without access to the sheet.
If she also needs a written sales and operations update, a weekly pipeline and operations briefing pulls from different sources and comes back as a document.
Your Midpoint worker has its own computer and browser, so it opens Sheets and Slides the way you do. Give it access to the approved sheet and the template through the Google account it will use, or save a website login for it. Name the reporting month, the warehouses and the slides, and ask it to confirm it can open them.
Prepare last month's warehouse deck in a copy of our template. Check each figure against the approved sheet, link its source and leave unfinished figures as questions for me. Send me the draft and don't share it with anyone else.


