Guides
Curated implementation, ROI, role, industry, and tool guides. News briefs and direct comparisons remain in their own collections.
Fix Missing Email Attachments in a Power Automate Intake Flow
Trace attachment metadata and file content separately, retrieve the intended files and reconcile each request before marking intake complete.
Fix a Looker Studio Date Filter That Uses the Wrong Business Date
Trace a date control to each chart’s date-range dimension, then reconcile five sample orders before changing a bookings or delivery dashboard.
Keep the Latest Record in Power Query Without Trusting Sort Order
Choose the latest record with an explicit per-ID rule, hold ambiguous ties and reconcile every ID before replacing a current-status report.
Start a Slack Agent Conversation from an Intake Workflow
Gather a clear request, start an agent conversation as the workflow’s final step and give a person ownership of the resulting draft brief.
Review Gemini Edits Across a Google Slides Deck Before Sharing
Use a bounded change brief and a 12-slide acceptance check to review Gemini edits before sharing an updated client presentation.
Fix Power Query Missing-Column Errors Without Hiding Bad Data
Find the first broken step, distinguish required from optional columns and test a repair before accepting a changed source export.
Fix Wrong Percentage Totals in Looker Studio
Rebuild a dashboard percentage from its numerator and denominator, then test totals and filters with a small reconciled example.
Stop Duplicate Power Automate Actions Without Losing Real Requests
Trace duplicate flow effects, define a stable operation key and reconcile uncertain outcomes before retrying a Power Automate request.
Find Missing Slack Later Items and Rebuild Your Follow-Up List
Find items after Slack’s Later-to-To-dos change, reconcile reminders and rebuild a small follow-up list without losing unfinished commitments.
Check a Gemini-Generated Renewal Tracker Before Moving It to Sheets
Test a Gemini-generated renewal tracker with known dates, missing inputs and repeat records before relying on it in Google Sheets.
Fix Power Query Rounding Differences Before Changing the Total
Trace rounding differences to the calculation stage, midpoint rule and data type, with small test cases before changing a reconciliation query.
Import Mailchimp Contacts Without Losing Opt-Outs or Good Data
Reconcile subscription status, duplicates and field updates before a Mailchimp import, then verify the results before sending a newsletter.
Verify a Slackbot Skill with a Test Pack, Not Just a Badge
Give a verified Slackbot skill a named owner, bounded job, test cases and change record before making it the default for a team.
Move Compact Pivot Tables Between Excel and Sheets Without Losing Meaning
Test compact pivot layouts with a reconciled cost example, clear hierarchy and an Excel return check before using them for recurring reporting.
Check Gemini’s Cell Citations Before Trusting a Supplier Comparison
Use Sheets cell citations to review supplier facts, record unknowns and measure verification work before expanding an AI-filled comparison.
Give Temporary Google Workspace Admin Access an Expiry and a Handoff
Plan short-term administrator cover with a narrow role, explicit expiration, acceptance checks and a handoff for work that outlasts the assignment.
Pilot Label-Based Google Support Approvals Without a Coverage Gap
Map file ownership, labels and existing policies before piloting Google Workspace support-access rules, with coverage tests and an approval rota.
Fix Airtable Emails Showing the Wrong Date or Time
Keep the original appointment timestamp, format a separate local-time message field and test midnight and daylight-saving cases before sending.
Fix HubSpot Renewal Workflows That Do Not Re-enroll
Diagnose date-based re-enrollment, check schedule eligibility and build a renewal task process that catches missed cycles without duplicate outreach.
Stop XLOOKUP Returning the Wrong Price from Duplicate Records
Find ambiguous lookup keys, build an approved price table and test missing, duplicate and revised rates before releasing an order or budget.
Fix a Looker Studio Filter That Changes Only Some Charts
Trace filter scope and field IDs across data sources, repair compatible fields and test actual-versus-target totals before sharing the report.
Fix a Notion Handoff That Stops After the First Automation
Replace an unsupported Notion automation chain with a clear handoff, then verify owner assignment and duplicate handling on real-shaped test records.
Fix Power Query Pivot Errors Without Choosing the Wrong Value
Find duplicate pivot intersections, choose a business rule for competing values and reconcile a supplier comparison before refreshing it.
Check Recurring Meetings Across Three Google Calendar Time Zones
Use Google Calendar’s three-zone view to check recurring meetings around daylight-saving changes and agree whose working hours take priority.
Prepare Workspace AI Connections for the November OAuth Change
Identify affected Workspace MCP connections, separate mixed-use clients and test a controlled change before Google’s November enforcement dates.
Stop Overlapping Zapier Paths from Routing a Request Twice
Make Zapier routing rules mutually exclusive, test boundary cases and keep fallback handling separate from failed-action recovery.
Fix Google Sheets QUERY Values That Disappear as Blanks
Diagnose blank QUERY results in Google Sheets, normalize amounts without changing identifiers and reconcile every source row.
Fix Power Query Errors Without Silently Dropping Records
Keep failed Power Query rows visible, repair conversion problems and reconcile accepted records before you release the report.
Keep an Interpreter Visible in Google Meet on Mobile
Prepare Google Meet tile pairing on mobile, rehearse interpreter visibility and agree on a fallback before the meeting starts.
Change Google Vids Clip Speed Without Rushing the Training
Adjust Google Vids clip speed with a timing budget, protect critical instructions and test whether a learner can complete the demonstrated task.
Fix an Airtable Rollup That Includes Unapproved Project Costs
Build an approved-cost rollup in Airtable, reconcile missing links and amounts, and keep shared expenses from inflating project totals.
Set Up Asana Recurring Tasks Without Losing the Next Check
Understand when Asana creates the next recurring task, choose a repeat rule and test the handoff without marking unfinished work complete.
Fix an Excel PivotTable That Leaves Out New Rows
Find why an Excel PivotTable misses new transactions. Check the source boundary, refresh and filters, then verify both record counts and amounts.
Update Gemini Notebook Sources from Chat Without Losing the Approved Version
Use the Gemini Notebook connected app to update a source collection with a change log, a narrow request and checks on the saved evidence.
Find a Missing Google Chat Meeting Recap and Confirm the Next Steps
Check rollout, meeting notes and chat settings when a Google Chat recap is missing, then turn suggested next steps into confirmed work with an owner.
Stop Make Webhook Runs from Overwriting Newer Updates
Diagnose out-of-order Make webhook updates, test Process data in order and protect newer records from delayed events. Includes a queue-capacity example.
Fix Inflated Costs in a Looker Studio Blend by Matching the Reporting Level
Diagnose inflated spend in a Looker Studio blend, align campaign and lead data at the right level and verify totals before using cost-per-lead figures.
Fill Down in Power Query Without Assigning Rows to the Wrong Group
Repair grouped exports with Power Query Fill Down, preserve section boundaries and check blank, null and unknown values before loading a report.
Update a Training Video in Google Vids Without Re-recording Every Scene
Use Google Vids audio extraction to revise a training clip, align narration with new scenes and check the exported result. Includes a timing worksheet.
Test a Google Vault Export of Gemini in Workspace Before Relying on It
Run a small, authorized Gemini in Workspace export rehearsal in Google Vault. Check scope, dates, missing items and source links before relying on the result.
Import HubSpot Contact–Company Associations Using Record IDs
Link existing HubSpot contacts and companies with a checked import file, verify relationship pairs and repair mistakes without duplicating records.
Fuzzy Match Supplier Names in Power Query Without Combining the Wrong Firms
Use fuzzy matching to suggest supplier-name matches, review ambiguous candidates and reconcile spend before loading a report. Includes a mapping worksheet.
Audit Gemini Connected Apps Before Adding Another Integration
Use Gemini’s Customize hub to inventory connections, check work-account controls and test what still works after access changes. Includes a review worksheet.
Use Google Meet Speech Translation for a Checked Supplier Handoff
Prepare a multilingual supplier status call with Meet speech translation, confirm quantities and dates, and handle errors before they become commitments.
Use Google Sheets Box Plots to Find the Service Delays Averages Hide
Build a box and whisker chart in Google Sheets, check the underlying cases and separate a long delay from a data error. Includes a worked example.
Power Automate Only Reads 256 Excel Rows? Verify the Whole Batch
Enable pagination when Excel rows stop at 256, then check table boundaries, filters and destination IDs before replaying missing work.
Airtable Find Records Missing Rows? Check Each Limit Separately
Trace missing Airtable records from conditions through action limits, repeating groups and email summaries. Reconcile the work before running it again.
Unpivot Monthly Columns in Power Query Without Losing the Meaning
Turn month columns into reporting rows, preserve the difference between zero and missing data, and test what happens when next month arrives.
Review a Gemini Notebook Slide Outline Before Rendering the Deck
Use the new outline review step to check a business-case deck before rendering. Includes a six-slide brief, worked costs and a manual fallback.
Use Docs Live to Turn Site-Visit Notes Into a Checked Report
Turn spoken visit notes into a useful service report with Docs Live. Check observations, dates, costs and approvals before assigning the next job.