Spreadsheet Guide
Google Sheets Setup Guide
This page is only for installing and using the Google Sheets add-on. It does not require you to read the API reference first.
Before you start, make sure you already have a Secwyn account and a valid API key from your dashboard.
Step-by-Step Installation
- Click Download Code.gs on this page.
- Open the Google Sheet where you want to scan emails.
- In the top menu, click Extensions > Apps Script.
- When the Apps Script editor opens, delete the sample code that is already there.
- Open the downloaded Code.gs file on your computer.
- Copy everything from Code.gs and paste it into the Apps Script editor.
- Click the Save button in Apps Script.
- Go back to your Google Sheet and refresh the page.
- After refresh, look at the top menu and find Risk Scanner.
Connect Your API Key
- Open your Secwyn Dashboard.
- Find your API key and copy it.
- Return to Google Sheets.
- Click Risk Scanner > Settings.
- Paste your API key into the API key field.
- Keep the default API base URL unless you were told to change it.
- Save the settings.
Google Sheets batch scanning uses the API. It requires a Growth, Scale, or Business plan.
Run Your First Scan
- Put one email address in each row of a column in your sheet.
- Select the cells you want to scan.
- Click Risk Scanner > Scan Selected Emails.
- Wait for the scan to finish.
- The add-on will write the results into new columns beside your selected emails.
Common Questions
I clicked the menu but nothing happened.
Refresh the Google Sheet after saving the script. The custom menu only appears after reload.
Google asks for authorization.
That is normal the first time. Google Apps Script needs permission to run inside your sheet.
I do not have an API key yet.
Open the dashboard first, generate or copy your API key, then come back to the sheet settings.
Need the API reference too?
The API docs stay separate so developers can jump straight into endpoints.