Vol. I · No. 22

Back Office Beat

Mon–Fri, 6:30 a.m. MT · Three to five items · Free

Published by J9 Systems
Subscribe

The daily brief · No. 22

Friday, November 6, 2026

Google Forms adds Gemini 'actionable insights' to survey responses, announced Nov. 5

By Carter Josephson · Filed 5:06 AM MST MT

Google Forms now uses Gemini to summarize survey responses and suggest next steps, at $0 extra on Business Standard or Plus. Today, run it on one existing survey, about an hour of your time, and see if the summary saves you work.

In this brief

  1. 1Google Forms adds Gemini 'actionable insights' to survey responses, announced Nov. 5Try it
  2. 2ACA affordability line rises to 10.22% of income for 2027 plan years, up from 9.96%Ask your vendor
  3. 3Section 127 tax-free tuition cap of $5,250 starts rising with inflation in 2027Wait
  1. Google Forms adds Gemini 'actionable insights' to survey responses, announced Nov. 5

    If you run customer or job surveys in Google Forms, Gemini can now summarize the responses and suggest next steps, possibly saving your office a few hours a month.

    By Carter Josephson · · Share this item

    What happened

    On Nov. 5, 2026, Google announced actionable insights in Google Forms, which uses Gemini to analyze form responses, surface key trends and recommend next steps, generated directly from a form's Responses tab. Google says Gemini analyzes the responses by writing and running Python code, so counts, percentages and comparisons are grounded in the actual response data.

    What it means for a 10-to-50-person business

    Per Google, the feature is available on Business Standard and Plus (and Enterprise and Education Plus), not on Business Starter. Rollout is gradual: it began Nov. 2 for Rapid Release domains and starts Nov. 19 for Scheduled Release domains, with up to 15 days before it shows up. Take a 25-person cleaning company that sends a survey after every job and gets about 300 responses a month. If the office manager spends 3 hours a month tallying them and Gemini cuts that to 30 minutes, the shop saves about 2.5 hours, roughly $75 a month at $30 an hour. Google says Gemini writes and runs Python on the responses, so counts are calculated, not guessed. The suggested next steps are still opinions, so check them against what you know. Skip it if you are on Business Starter or use Jotform or SurveyMonkey.

    What to do
    Try it

    This month, open the Responses tab on your busiest Google Form; if the insights option appears, compare its counts and top trends against a month you already summarized by hand.

    What it costs
    What it costs
    Feature cost
    $0 extra on Business Standard or Plus; not available on Starter
    First test on one survey
    1 hr (about $30 at $30/hr)
    Manual summary today, assume 300 responses/mo
    3 hrs/mo (about $90)
    Possible saving if Gemini cuts that to 30 min
    about $75/mo, $900/yr
    Doing nothing
    $0; keep summarizing by hand or in Sheets
    Sources
    workspaceupdates.googleblog.com (primary)
  2. ACA affordability line rises to 10.22% of income for 2027 plan years, up from 9.96%

    It matters if you have 50 or more full-time staff or are about to; under 50, the effect is small.

    By Carter Josephson · · Share this item

    What happened

    The IRS published Rev. Proc. 2026-26 on July 21, 2026, setting the required contribution percentage at 10.22% for plan years beginning in 2027, up from 9.96% for 2026.

    What it means for a 10-to-50-person business

    Employers with 50 or more full-time equivalents must offer coverage whose employee-only cost is no more than that share of income, or risk a penalty. At 10.22%, a worker earning $50,000 can be charged up to $5,110 a year ($426 a month) and still count as affordable, against $4,980 now. Most owners with 10 to 50 staff are not subject to that rule, so for them the effect is small. It applies if you sit near 50 employees, since hours of part-timers count toward the total. A plan year that starts before January keeps 9.96% until its next start date.

    What to do
    Ask your vendor

    If you are near 50 full-time equivalents, ask your broker or payroll provider to rerun employee-only contribution rates against 10.22% before open enrollment.

    What it costs
    What it costs
    Maximum affordable charge at $50,000 pay
    $5,110/yr in 2027 vs $4,980 in 2026
    Broker or payroll check
    1 hr (about $30 at $30/hr)
    Doing nothing
    $0 under 50 FTEs; at 50 or more, penalties apply if rates miss the line
    Sources
    irs.gov (primary)
  3. Section 127 tax-free tuition cap of $5,250 starts rising with inflation in 2027

    If you pay for employee schooling or student loans, the cap is flat this year and indexed from next year.

    By Carter Josephson · · Share this item

    What happened

    The IRS's April 2026 fact sheet (FS-2026-10) says employers can exclude up to $5,250 per employee per calendar year of educational assistance, and that the limit is adjusted for cost of living for tax years beginning after 2026. It also says an employer must tell workers whether a section 127 program exists, and that the program must be a separate written plan.

    What it means for a 10-to-50-person business

    The change is small and not urgent. Take a 20-person electrical contractor that pays $3,000 a year toward an apprentice's classes. That sits under the cap today and under any likely 2027 figure, so nothing changes. It matters only if you pay near $5,250 per person, or pay student loans through a plan. The IRS has not published the 2027 dollar figure yet. The practical risk is paying benefits without a written plan, which can make the money taxable wages.

    What to do
    Wait

    If you reimburse tuition or loans, confirm you have a written section 127 plan this month. Watch for the IRS's 2027 dollar figure before setting 2027 budgets.

    What it costs
    What it costs
    Written plan check
    1 hr (about $30 at $30/hr, or ask your payroll provider)
    Cap today
    $5,250 per employee per year, unchanged for 2026
    Doing nothing
    $0 if you have a written plan; if you do not, reimbursements above plain job-training rules can be taxable wages
    Sources
    irs.gov (primary)

Also happened

Corrections and updates

None. How corrections work.

Get the next one at 6:30 a.m.