Overview

The Google Sheets integration keeps a Google Sheet that you own up to date with the profiles in your Database. Vome writes your active profiles to one tab, and can also write your archived profiles and any saved Database view to tabs of their own. You choose which fields are synced and how often the sheet updates. Organizations use it to keep a live copy of their Database, to build reports, or to start workflows in other tools.

Plan required: The Google Sheets integration is available on the Pro plan and above. Custom fields are synced on the Enterprise and Ultimate plans, the same plans that show custom fields in the Database.

1. What does the integration do, and what does it not do?

• Vome writes your Database profiles into one Google Sheet, one row per profile, sorted by name.
• It goes one way. Anything typed, edited or added in the sheet never comes back into Vome.
• Active and archived profiles are never mixed. Active profiles always have their own tab, and archived profiles get a separate tab only if you turn it on.
• One sheet per organization. If you paste the link of a sheet that is already connected to another organization, Vome refuses it.
• Tabs you create yourself are never read, cleared or changed by Vome.

2. Who can set it up, and where do I find it?

You will find the integration in two places: Integrations & Apps > Google Sheets, or Database > Settings > Tools > Google Sheets integration. The sync settings described below are on the Integrations & Apps page.

The account holder and super admins can connect a sheet, change its settings, run an export and disable the integration. So can any admin whose role includes the Manage Google Sheets integration permission.

3. How do I connect a Google Sheet?

1. Create a new Google Sheet from your Google account. The file can have any name, for example "Vome Database". The Vome popup has a Create a Google Sheet button that opens a new blank sheet in a new tab.
2. In the sheet, click Share at the top right.
3. In the Share window, click Copy link, then paste the link into the Vome popup.
4. Copy Vome's email address from the popup and paste it into Add people in the same Share window.
5. Set Vome as Editor, click Send in Google, then come back to the Vome popup and click Connect.

Vome checks that it can open the sheet, then runs the first export right away. If the sheet only has Google's default empty tab (Sheet1, or Feuille 1 in French), Vome renames it to Active profiles and fills it in. You do not need to rename any tab yourself.

4. Which tabs does Vome write?

• Active profiles: always on. Every active profile linked to your organization.
• Archived profiles: turn on Archived profiles tab in the sync settings. It holds archived profiles only, with the archived date and who archived them next to the name.
• Custom view tabs: add any saved Database view under Custom view tabs. Each one becomes its own tab, named after the view, with that view's columns, column order and filters. If you edit the view in the Database, the tab follows on the next sync.

Vome finds its tabs even if you rename or move them. If you delete a Vome tab that is still turned on, Vome creates it again on the next sync.

5. Which fields are synced?

By default, Sync every Database field is on. The Active profiles and Archived profiles tabs then carry every field your Database can show, including email, phone, address, profile tags, groups, sites, opportunities, categories, hours, shifts, emergency contact and, on Enterprise and Ultimate, your custom fields. New custom fields are added to the sheet automatically.

To sync only some fields, turn Sync every Database field off and click Choose fields. The fields you pick become the columns of the Active profiles and Archived profiles tabs, in the order you add them. Custom view tabs always use their own view's columns.

Column headers use the same names as the Database, in the language of the admin who connected the sheet or last changed its settings. Impact value and Activity Status only appear if your organization has turned them on in the Database.

6. What does each cell contain?

The same values you see in the Database, written so they are easy to work with in a spreadsheet:

• An empty value is a blank cell, where the Database shows N/A.
• Several values in one field, such as profile tags or opportunities, are separated by a semicolon.
• Dates are written as year-month-day, for example 2026-11-06, so they sort correctly.
• Counts and hours are real numbers, so you can add them up or chart them.
• Text is always written as text. A value that starts with an equals sign is never turned into a formula.

7. How often does the sheet update?

You decide. Under How often it syncs, choose Every hour, Every 6 hours, Once a day (the default) or Once a week. All times are Eastern time:

• Every hour: at the top of each hour.
• Every 6 hours: at midnight, 6 AM, noon and 6 PM.
• Once a day: at midnight.
• Once a week: Monday at midnight.

Click Run export any time to update the sheet right away. It does not change the schedule. Changes to the fields or tabs save right away and apply from the next sync, usually within 15 minutes.

Connected your sheet a while ago? Earlier versions wrote 16 fixed columns to the first tab. On the first sync with the new settings, that tab becomes your Active profiles tab and gets every Database field, so its columns change. Formulas that point at a column by its letter may need updating. To keep a shorter list, turn Sync every Database field off and choose your fields.

8. Can I edit the sheet?

Not on Vome's tabs. On every sync, Vome clears each of its tabs and writes the headers and values again, so edits, added rows and sorting on those tabs are replaced. Formatting such as colours and column widths stays, and the header row stays frozen.

Tabs you create yourself are never touched, so that is the place for your own notes, formulas, charts and pivot tables.

Tip: Build your reports on a tab of your own and point the formulas at Vome's tabs, for example a COUNTIF over the Active profiles tab. They refresh every time Vome syncs.

9. What happens when I turn a tab off?

When you turn off Archived profiles tab or remove a custom view tab, Vome asks what to do with it:

• Keep tab: the tab stays in your sheet as it is now, and Vome stops updating it.
• Delete tab: Vome removes the tab from your sheet on the next sync.

10. How do I know the last sync worked?

The Google Sheets page in Integrations & Apps shows when the sheet was last synced. If a sync fails, the page says so and tells you why:

• "Vome can no longer open your Google Sheet. Make sure it is still shared with Vome as an Editor." Share the sheet with Vome's email address again, as Editor.
• "Your Google Sheet could not be found. It may have been deleted. Disable the integration and connect a new sheet."
• "Your data is too large for one Google Sheet. Choose fewer fields or tabs." Google allows 10 million cells per spreadsheet, across all tabs.

When you click Run export, the page waits for the result and tells you whether the export finished or failed. If a sync keeps failing, submit a ticket or write to support@vomevolunteer.zohodesk.com.

11. How do I turn the integration off?

On the Google Sheets page in Integrations & Apps, or in Database > Settings > Tools > Google Sheets integration, click Disable. Vome stops updating the sheet. The file and everything already in it stay in your Google Drive.

Summary

• One way only: Vome writes your Database profiles into a Google Sheet you own, and nothing comes back from the sheet.
• Pro plan and above. Custom fields sync on Enterprise and Ultimate.
• Share the sheet with Vome's email address as Editor, paste the link and click Connect. No tab needs renaming.
• Active profiles always have their own tab. Archived profiles and saved Database views can each have one too.
• Every Database field by default, or only the fields you choose, with the same column names as the Database.
• Syncs every hour, every 6 hours, once a day or once a week, and whenever you click Run export.
• Keep your own work on your own tabs. Vome rewrites its tabs on every sync.