G-Connector: Google Sheets Integration
Import, export and automatically refresh Salesforce data in Sheets
Overview
Enjoy bi-directional live data sync between Salesforce and Google Sheets. Schedule Salesforce reports and harness data for deep insights. For teams who want to report, edit, automate and work collaboratively with Salesforce data.
See How G-Connector: Google Sheets Integration Works
Schedule automatic refreshes of a Salesforce report or data pulled via SOQL. The updates are running even when you're offline!
Keep historical data by creating report snapshots in your Google Drive automatically up to every hour.
Run metrics on your data up to once an hour and send out scheduled notifications or alerts to multiple people via Slack and email if a metric is off.
Mass insert, update, upsert, delete data. Both manually and automatically.
Send customized notification of what's going on with your data
Friction free data loader inside any Google Sheet
Dynamic SOQL based on existing data in your spreadsheet
Bypass Salesforce 2,000 row limit for report exports
This addon to Google Sheets will let you pull any data from Salesforce.com and schedule automatic refresh of that data even when you're offline. Pull a report, set up your update schedule (can be hourly, daily, weekly (on specified days), or monthly), then share the document with any number of non-salesforce users in Google Sheets and they will all near-real-time data access. Send team notifications and record alerts via Slack and Email every time your data changes! Have your team members access and edit Salesforce data in Sheets, then pull the updates back to Salesforce on a Schedule. Work offline, sync later. Enjoy multiple Fast data loader in a Google Sheet without having to deal with CSV files. Great for SLT reporting, backups, instant data manipulation, data migration and data cleanup. Lots of unique features not found in other similar software (Coefficient, Salesforce Connector, etc.).
Categories
- Business Needs
- Data ManagementData CleansingData Visualization
- Industries
- Financial ServicesHealthcare & Life SciencesHigh Tech
- Personas
- Data AnalystData ProfessionalSales Representative / Manager
- FeaturesLightning ReadyOptimized for Salesforce orgs that use Lightning Ready.Multiple CurrenciesSupports Salesforce orgs that use Multiple Currencies.Person AccountsSupports Salesforce orgs that use Person Accounts.Salesforce ShieldSupports Salesforce orgs that use Shield.
- Lightning ReadyMultiple CurrenciesPerson AccountsSalesforce Shield
Compatibility
- Required Salesforce ProductsThis solution requires these products in order to work. Before you implement the solution, check that you have these products.
- None
- Compatible Salesforce ProductsThis solution is tested to work with and extends the value of these products, but doesn't require them.
- Sales CloudService CloudPlatform Cloud
- Salesforce Editions
- ProfessionalEnterpriseUnlimitedForce.comDeveloper
- Supported Languages
- English