The first decision is which parts should never involve AI. Every figure stays deterministic and auditable; AI writes the paragraph nobody enjoys writing. Plus the failure mode that produces a normal-looking report from stale data.
A wrong formula affects one cell. A wrong script can rewrite ranges, delete sheets and send email as you. Here is what to look for before clicking run, and the quotas that break scripts at scale.
Three routes produce essentially the same formula. What differs is what each costs and how much you have to type. On Business Starter one of them is not available to you at all.
Gemini is included with Workspace, metered in Sheets, and absent from Business Starter entirely. Business Plus costs $8 more per user than Standard and has exactly the same 100-a-month allowance.
The code is the easy part. Google gives each custom function thirty seconds to return, so filling one down a thousand rows fires a thousand simultaneous calls and fills the column with errors.
Make a chart in Google Sheets and choose the right chart type for the data, rather than accepting whatever Sheets automatically suggests by default.
Add a signature in Gmail and set it as the default for both new emails and replies, avoiding the most common setup mistake people genuinely run into.
Convert a Google Doc to PDF using the built-in Download option, and avoid the most common formatting, comment, and image issues along the way.
Use Google Drive to store, organize, and share files, and understand the real difference between My Drive, Shared with me, and Shared drives.
Use Google Sheets effectively, from automatic saving and formulas to real-time collaboration and recovering mistakes with version history at any point.