Google Sheets Import Functions Planner for Public Data
Plan IMPORTHTML, IMPORTXML or IMPORTDATA use responsibly.
The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.
[VERIFY] is an editorial flag, not a blank to fill. Wherever the prompt shows [VERIFY], check that item against a reliable source before you use it.
I want to bring public data into Google Sheets with import functions. Source and what I need: [SOURCE_AND_NEED]. How often it changes: [CHANGE_FREQUENCY]. What I know about its terms of use: [TERMS_NOTES]. First help me check whether I am allowed to use the data and whether an official download, feed or API would be better; keep the advice about terms of use prominent. Then give a table with Function, Best for, Limits and Fallback: IMPORTHTML for tables and lists, IMPORTDATA for CSV, IMPORTXML for specific elements, IMPORTRANGE for my own sheets, with the formula structure using a placeholder address. Describe limits and common failures (page changes, blocked requests, refresh timing, quota) [VERIFY] and a fallback plan. Do not suggest ways of bypassing blocks or logins. Keep a dated copy of the values as a record, check the first import against the source by eye, and notice when an import stops working with a check cell comparing the row count with the expected number.
Fill in before use
Optional: type your details and the prompt above updates. Nothing is saved or sent.
Replace each bracketed placeholder with your own details, then paste into Any AI or another assistant.