Swallow
  • YOUR FIRST MODEL
    • Setting up your first project
    • Manual setup of a new product
    • Excel Model Upload
    • Create your team
    • Essential concepts
      • Syntax
      • Steps
      • Collections
      • Try Model
      • Spotlight
  • PROCESS
    • Team Management
    • Governance & Collaboration
  • BUILD
    • Building with AI
    • Step builder
      • Understanding step types
      • Ordering step blocks
      • Placeholder mode
      • Up/Downloading models
      • Sharing your model
      • Running tests
    • Inputs
    • Enriching Raw Data
      • Transform Data
      • Enrich via API
      • Data Set
      • Collection
      • Custom Code
    • Setting Up Decisions
      • Exclusions
      • Excesses
      • Endorsements
      • Refer
    • Making Calculations
      • Factors
      • Calculation
    • Outputs
  • TEST
    • Creating New Tests
    • Running Tests
    • Editing Tests
    • Reading & Interpreting Tests
    • Impact Testing
  • DATA
    • Working with real-time data
    • Data Views
    • Data Quotas
    • Troubleshooting
    • API Webhooks
    • Data Downloads
  • ADMIN & SETTINGS
    • Project Management
    • Account Management
  • INTEGRATIONS
    • Introduction
    • Payments
      • Stripe
      • GoCardless
      • Adyen
    • Alerting
      • Slack
      • Zapier
    • Data
      • AWS S3
      • Google Sheets
    • Admin
      • Socotra
      • Guidewire
      • Hubspot
      • Salesforce
  • Developer API
    • Introduction
    • Authentication
    • Errors codes
    • Endpoints
      • /quotes
      • /projects
      • /tests
      • /process
Powered by GitBook
On this page
  • Install
  • Configuration
  • Quote Creation Integration
  • Webhooks
  • Data Security
  1. INTEGRATIONS
  2. Data

Google Sheets

Swallow's integration with Google Sheets enables seamless data synchronization and reporting capabilities.

PreviousAWS S3NextAdmin

Last updated 3 months ago

Install

Installation Steps

  1. Navigate to the Integrations page in Swallow settings

  2. Select Connect to Google Sheets from the available integrations

  3. Click on the +Add connection button

  4. Follow the prompts to authenticate with your Google account and grant necessary permissions

  5. Once authenticated, select the Google Sheet you want to connect with Swallow

Configuration

Setting up Google Sheets Connection

  1. After selecting your Google Sheet, you'll need to specify which data you want to sync:

    • Choose the specific worksheet within your Google Sheet

    • Select the columns that correspond to Swallow's data fields

    • Set up the sync frequency (e.g., real-time, hourly, daily)

  2. Configure data mapping:

    • Map Google Sheets columns to Swallow's data fields

    • Specify any data transformations or formatting rules

Quote Creation Integration

Integration Details

Currently, the Google Sheets integration is primarily used for quote creation and management. When a quote is created or updated in Swallow, the relevant data is automatically synced to the connected Google Sheet.

Working

  1. When a quote is created or updated in Swallow, it triggers the Google Sheets integration

  2. The quote data is formatted according to the configured mapping

  3. The data is then inserted or updated in the specified Google Sheet

  4. Any changes made in the Google Sheet can also be synced back to Swallow, depending on the configuration

Note: This integration is currently focused on quote management. If you need to expand the integration to include other data types or functionalities, please contact Swallow support for assistance.

Webhooks

Setting up Webhooks

To set up webhooks for the Google Sheets integration:

  1. Navigate to Settings in Swallow

  2. Click on Webhooks

  3. Create a new webhook for quote creation and update events

  4. Use the generated webhook URL in your Google Apps Script to trigger updates in your Google Sheet when changes occur in Swallow

Data Security

Ensuring Data Protection

  1. Swallow uses OAuth 2.0 for secure authentication with Google Sheets

  2. All data transfers between Swallow and Google Sheets are encrypted

  3. You can control access permissions to the connected Google Sheet within your Google account

  4. Regularly review and update access permissions to maintain data security

Remember, when working with quotes in Swallow, use the "next button URL" to guide users through the quote completion process. The company_reference and quote_reference are used to identify specific entities within the system.

This integration allows for efficient management of quote data between Swallow and Google Sheets, enabling real-time updates and collaborative workflows.