Skip to main content
StoreInspect for Google Sheets brings Shopify company and contact intelligence into the spreadsheet you are already using. The add-on is available on paid StoreInspect plans.
The add-on is currently being prepared for Google Workspace Marketplace review. Test installations are limited to approved accounts until the public listing is available.

​
Connect StoreInspect

  1. Open a Google spreadsheet.
  2. Choose Extensions > StoreInspect > Open StoreInspect.
  3. Click Connect account in the sidebar.
  4. Sign in to StoreInspect and approve the requested access.
  5. Return to the spreadsheet and reopen the sidebar.
The add-on uses StoreInspect OAuth. You do not need to create or paste an API key.

​
Search Shopify stores

  1. Open the Stores tab in the StoreInspect sidebar.
  2. Add at least one filter, such as country, category, traffic tier, estimated revenue tier, Shopify Plus, technology, or contact availability.
  3. Choose the number of rows.
  4. Click Find Shopify stores.
Results are written to a new StoreInspect sheet. If another page is available, click Load more to append it to the same output sheet.

​
Search contacts

Use the Contacts tab to find masked decision-maker previews by role, store domain, country, or channel availability. Contact previews include StoreInspect contact IDs and availability signals. They do not expose private email addresses, phone numbers, or profile URLs until you explicitly reveal the contacts.

​
Enrich selected domains

  1. Select up to 25 cells containing store domains or URLs.
  2. Open Selected cells in the sidebar.
  3. Choose whether to include masked contact previews.
  4. Click Enrich selected domains.
The add-on creates a new enrichment sheet containing the input status, store profile, traffic and revenue tiers, Shopify Plus status, technologies, lead fit score, and contact availability.

​
Reveal selected contacts

  1. Select up to 10 cells containing StoreInspect contact IDs.
  2. Click Review contact reveal.
  3. Review the number of selected contacts and your remaining credits.
  4. Confirm the reveal.
Newly revealed contacts use StoreInspect contact credits. Contacts already revealed for your account do not spend another credit. Revealed data is written to a new StoreInspect sheet.

​
Spreadsheet access

The add-on requests permission to:
  • read and write only the currently open spreadsheet;
  • display the StoreInspect sidebar;
  • send HTTPS requests to StoreInspect.
It does not request access to Google Drive or other spreadsheets. StoreInspect actions create new output sheets by default and do not overwrite existing worksheet data.

​
Data safety

  • StoreInspect OAuth tokens are stored per user in Apps Script user properties.
  • Returned text that could execute as a spreadsheet formula is written as text.
  • Contact previews remain masked until an explicit credit confirmation.
  • Revealed contact channels should be treated as sensitive business data.

​
Disconnect

Open the StoreInspect sidebar and click Disconnect. The add-on removes its local OAuth tokens and attempts to revoke them with StoreInspect. Existing spreadsheet data remains unchanged.

​
Troubleshooting

  • StoreInspect menu missing: Reopen the spreadsheet after installing the add-on.
  • Connection expired: Connect the StoreInspect account again.
  • No positive filter: Add at least one store or contact filter.
  • Rate limit reached: Wait briefly before running the next request.
  • Insufficient credits: Add credits or change the StoreInspect plan before revealing new contacts.
  • Contact IDs not found: Select cells from a StoreInspect contact-preview output sheet.
Include the StoreInspect request ID shown by an error when contacting support.