Key Takeaways
- The Sheets AI Assistant suggests formulas and placement guidance for native Google Sheets functions and Flookup custom functions; it does not execute cleaning workflows on your sheet.
- Clear prompts that include ranges, column names and the desired outcome produce more useful formula suggestions.
- The assistant remembers recent exchanges, so you can ask follow-up questions to refine a formula without restating the whole problem.
- The assistant uses your own Google Gemini or OpenAI key, which you save in the sidebar Settings.
A common spreadsheet question is not whether to clean data, but which formula to use and how to adapt it to real columns. This case study follows a fictional membership association of about 1,200 members through three such jobs using Extensions > Flookup Data Wrangler > Sheets AI Assistant in Google Sheets. The organisation is a worked example, but the assistant behaviour described here follows the current Sheets AI Assistant documentation.
The association behind this case study
The association keeps its member list, event attendance logs and sponsor records in one spreadsheet and one operations coordinator owns all three. The member list holds renewal dates in mixed formats because two people have entered them over five years. The attendance logs arrive from two event platforms with different name spellings. The sponsor list contains variants such as Acme Freight Ltd, ACME FREIGHT LIMITED and Acme Freight.
Each need is a one-off question: which formula finds renewals due soon, how to match names across lists and how to standardise or deduplicate sponsor names. The assistant helps by suggesting formulas the coordinator can review and apply.
Open the assistant
In Google Sheets, open Extensions > Flookup Data Wrangler > Sheets AI Assistant. Select the relevant range or note the sheet names and columns before asking, so the prompt can include concrete ranges such as A2:A or Sheet2!A2:D.
Ask for a renewal-report formula
The first job was a renewal report. The coordinator needed members whose memberships expire within sixty days, using the renewal date in column D and returning the member name from column B. The prompt described the task in plain language and named both columns and the desired result.
The assistant returned a suggested formula with guidance on where to place it and how the parameters related to the selected ranges. It did not change the sheet. The coordinator pasted the formula into a scratch column, checked it against known renewals and then filled the report once the result looked correct.
Review before applying. Treat every suggested formula as guidance until you have checked it on your data, especially when the sheet contains mixed formats, blanks or important records.
Refine the answer in the same session
The first answer needed a small adjustment because blank renewal cells produced unwanted results. The coordinator asked a follow-up question in the same session: make the formula ignore blank rows. Because the assistant remembers the last few exchanges, the follow-up did not need to repeat the full context.
A second follow-up asked how to handle renewal dates stored as text rather than dates. The assistant suggested an adjusted formula for that case. When switching to a completely different task, starting a fresh conversation helps keep the context clear.
Get formulas for matching and deduplication
For the attendance and sponsor lists, the coordinator asked for formula approaches using Flookup custom functions and native Google Sheets functions where useful. Example prompts included fuzzy matching names against a member list, normalising company names and extracting or keeping unique values.
- Fuzzy matching: ask for a formula that compares names in one range against another and returns the best match or similarity score, for example with
FLOOKUPorFUZZYSIM. - Standardisation: ask how to clean punctuation, spacing, diacritics or case with
NORMALIZEor native functions. - Deduplication and unique values: ask for a formula using
DEDUPEorULIST, or a native approach, depending on the sheet structure.
For supported large batch jobs that need scheduled processing, the coordinator can use Data Cleaning Automation separately from the assistant.
Review and apply formulas safely
The practical habit in this case study was simple: ask for the formula, read the explanation, apply it in a test area and verify a few known cases before copying it across the full range. That keeps an untested suggestion away from the member list and makes it easier to spot issues caused by mixed formats or unexpected blanks.
Setup and scope
The assistant uses your own AI provider account. In Settings, choose Google Gemini or OpenAI, paste your API key and select Save key. Your key is stored in your Google account and is sent only to the provider you choose.
The assistant is designed for Google Sheets formula and data-operation questions. It provides guidance and suggested formulas in the sidebar for you to review and apply.
Frequently Asked Questions
Does the assistant edit the sheet directly?
No. The Sheets AI Assistant provides formulas and placement guidance for you to review and apply in your sheet.
Which functions can the assistant suggest?
It can suggest native Google Sheets functions and Flookup custom functions such as NORMALIZE, FUZZYSIM, FLOOKUP, SHEETMERGE, QLOOKUP, HFLOOKUP, ULIST and DEDUPE, including combinations where appropriate.
Can I ask follow-up questions?
Yes. The assistant remembers your last few exchanges, so you can refine a formula or ask a related follow-up in the same session.
Do I need my own AI key?
Yes. In the assistant Settings, choose Google Gemini or OpenAI, paste the API key from your provider account and save it. Flookup does not supply AI access.