My Public Data (Google Sheets)
Track your public figures and KPI from the Google Sheets docs. Quick hint: The Google Sheets doc should be in public access so if you’d like to track data from the internal docs, you can import this specific number to the doc with public access using the following formula: IMPORTRANGE(“spreadsheet_url, range_string”, “Sheet_name!Cell_number”). Example: =IMPORTRANGE("https://docs.google.com/spreadsheets/d/1IktVbkNWkBQ4", "Sheet1!A9"). Track only those data which can be shared with others! P. S. The data updates once in 10 minutes.