What Sheetly does

Sheetly Sync connects Notion databases to Google Sheets so you can analyze, chart, and share data—without exporting CSVs. You can import Notion data into Sheets, refresh with one click, and (Pro) push updates back to Notion or run Auto Sync.

Prerequisites

  • A Google account with access to Google Sheets

  • A Notion workspace (you’ll create a Notion integration token)

  • Optional for Pro: a Stripe subscription (from inside the add-on)

1) Install the add-on

  1. Open any Google Sheet.

  2. Go to Extensions → Add-ons → Get add-ons.

  3. Search “Sheetly Sync” and click Install.

  4. Grant the minimal permissions (current spreadsheet, email, UI).

Tip: If your domain enforces marketplace restrictions, ask your admin to allow Sheetly for your OU.

2) Open the sidebar

  • In your Sheet: Extensions → Sheetly → Open.

  • The sidebar shows your connection status and actions.

3) Connect Notion (one-time)

  1. In Notion, create an Internal Integration (Settings → Connections → “New integration”).

  2. Copy the Integration Secret (token).

  3. In the Sheetly sidebar, click Connect Notion and paste the token.

  4. In Notion, go to the database you want to sync → Share → Invite your integration → Allow access.

You must grant your integration access to each database/page you want Sheetly to read/write.

4) Import a Notion database into Sheets

  1. In the sidebar, click Load Databases.

  2. Pick a database (or a saved view with filters).

  3. Choose Import.

  4. Sheetly creates/uses the current sheet tab and writes a header row followed by records.

Supported property types (auto-mapped): text, number, select, multi-select, people (names or emails), date, checkbox, URL, email, phone, formulas (value), relations/rollups (as names/IDs when available).

5) Refresh data (pull latest from Notion)

  • Click Refresh to fetch changes from Notion and update the sheet without breaking formulas/charts.

  • If you selected a Notion view, Sheetly respects its filters and sorts.

6) (Pro) Write back to Notion

You can send edits made in Sheets back to Notion.

Workflow

  1. Import a database (Step 4).

  2. Edit values in the rows (only for properties your integration has permission to edit).

  3. Click Push to Notion.

  4. The sidebar shows a summary of created/updated rows.

Notes

  • Only editable properties are written; computed fields (e.g., formulas/rollups) are skipped.

  • Relations: you can push by display name or ID if available.

  • Conflicts: latest write wins; we recommend refreshing before pushing.

7) (Pro) Auto Sync

Automate your syncs without keeping the sheet open.

  • Auto Pull: fetch from Notion → Sheets every 15 minutes.

  • Auto Push: send changes from Sheets → Notion every 15 minutes.

  • Toggle from the Auto Sync section in the sidebar.

Auto Sync respects your last configuration (database/view and mapping). You can disable either direction independently.

8) Column mapping & formatting

  • The first row is treated as headers. Ensure each column name is unique.

  • You can rename headers—Sheetly remembers mappings by Notion property ID.

  • Avoid merged cells in the data range; they block updates.

  • Protected ranges are fine for read, but will block write-back.

9) Limits & performance

  • Very large databases: import in pages/batches; filters in Notion can reduce payload.

  • Google quota applies (Apps Script). If you hit a limit, wait and retry, or split syncs.

  • Dates use your Sheet’s locale/timezone; adjust in File → Settings if needed.

10) Licensing (Pro)

  • Upgrade inside the sidebar (Stripe checkout).

  • Pro features unlock immediately; if not, click Refresh License.

  • Cancel anytime; Pro access continues until the end of the billing period.

Troubleshooting

“Connected to Notion” is not checked

  • Verify your token is correct and not expired.

  • In Notion, Share → Invite your integration to the database.

Database not showing in the picker

  • Ensure your integration has access to that database.

  • Refresh the list with Load Databases.

  • Check that the database isn’t inside a private page without integration access.

Write-back fails for some columns

  • The property may be read-only (formula/rollup) or a relation requiring IDs.

  • Try pushing a simple field (text/number) first to confirm permissions.

“Pro features locked” after paying

  • Click Refresh License or reopen the sidebar.

  • If it persists for more than a minute, contact support with your billing email.

Apps Script error / quota

  • Try again in a few minutes. For large imports, narrow your view or import in parts.

Frequently Asked Questions

Do you store my Notion or Sheet data?
No. Data is processed in memory to perform your sync. We store your email and license status for access control. See our Privacy Policy.

Why do you need these permissions?

  • Current spreadsheet access to read/write the sheet you chose

  • Email to check Pro license

  • UI/locale/script app for sidebar, settings, and automation

  • External requests to call Notion’s API and our license endpoint

Can I choose which columns to import?
Yes—import a Notion view with your preferred columns/filters; Sheetly respects it.

Can multiple people use the same sheet?
Yes. Anyone with access to the Google Sheet can see the imported data. Write-back uses the integration’s permissions.

How do I uninstall?
Google Sheets → Extensions → Add-ons → Manage add-ons → Sheetly → Uninstall. (Uninstalling doesn’t cancel a paid plan—email support or use your Stripe receipt link.)

Support

Need help? Email [email protected] or visit sheetly.cc/support.
Business hours: Mon–Fri, 9:00–6:00 ET. Target response: within 1 business day.

Release notes (optional section you can keep updated)

  • v1.0: Initial public release — Import, Refresh, Write-back (Pro), Auto Sync (Pro).

Legal

Sheetly Sync is provided by Glencrest Capital LLC. Google, Google Sheets, and Notion are trademarks of their respective owners. Sheetly is not affiliated with Google or Notion.