Connector Details

Google Sheets

hotglue Docs

The ETL platform to build the integrations your customers want

Introduction

Welcome to hotglue

Get answers to all your questions on hotglue.

What hotglue environments are, and how to use them

Environments

Connect your customers to integrations with powerful links

Magic Links

Overview

This guide walks through writing a basic transform script using the gluestick package

Writing a basic script

Debugging a script

Snapshots

Sample Scripts

Learn how to build custom targets using the Singer SDK

Building targets

Learn how the unified schema works and how to use it.

Accounting Schema

E-Commerce Schema

CRM Schema

Widget settings

Fully white label your user OAuth experience

White-label

Set up job settings and webhook monitoring

Job settings

Integrate hotglue with your own workflow by configuring a webhook

Webhooks

Example overview page before API endpoints

Environment Variables

A brief overview of the hotglue CLI and installation options

Configuration

Flows

Jobs

Tenants

Start making requests to the hotglue API!

Secure Requests

The following endpoints apply for V1, one-way flows

Kicks off a job for a given tenant. When using the API tap, you can pass a payload in the `state` object to be written to the target.

Run a V1 job

The following section applies to V2 bidirectional flows.

Kicks off a job for a given tenant. Can be used to write data in target flows by passing a payload in the state object.

Run a V2 Job

Write data directly to integrations in real-time. Note: this feature is in beta with limited support.

Write to a connector

If a real-time write request returns async: true, you can use this endpoint to get the result of the request.

Poll write request

API Reference

Unified Schemas

Dashboard

Status

Map tenant IDs to names, plans, and other identifiers using metadata

Tenant Metadata

Subtenants

The Default Tenant

The `job_details.json` object describes metadata about a job. Each job lifecycle webhook will contain corresponding job details for that stage.

Job Details

Sync Jobs

Life Cycle

Scheduling

What are write jobs and how do you use them?

Write Jobs

Connectors

V1 Source Flows

V1 Target Flows

V2 Bidirectional Flows

The hotglue widget allows you to offer native, inline integrations in your app with a few lines of code.

Using the hotglue widget with plain JavaScript

Javascript Reference

This changelog documents the updates, enhancements, and bug fixes for the `@hotglue/widget` package.

Changelog

A Python library for efficient ETL processes, optimized for hotglue

Introduction to Gluestick

Read Data

Data Reading Functions

Snapshotting

Snapshotting functions

Functions for processing and transforming JSON and object data in pandas DataFrames

JSON & Object Handling

Functions for cleaning, mapping, and transforming data in pandas DataFrames

Data Transformation

Data Transformation Functions

Functions for exporting data to various formats and handling errors in ETL pipelines

Export Data

Data Export & Error Handling

Handle advanced use cases in the transformation scripts

Use Cases

Learn how to use the transformation scripts to push data directly to your API

Push to APIs

How to add custom parameters to the hotglue widget

Custom Params

How to handle typing and primary keys with transformation scripts

Typing and Primary Keys

Learn how to create custom taps using the Connector Builder

Connector Builder

Learn how to run custom taps using the Singer SDK

Singer SDK

AWS Cognito

Abicart

Abra

ActiveCampaign

Affinity

Agile CRM

Altium 365

Amazon Ads

Amplitude

App Store Connect

AppsFlyer

Asana

Auth0

Azure Active Directory

Bexio

Blackbaud

Campaign Monitor

Capsule

Chargify

Cin7

ClickUp

Clockify

Close

Contentful

Copper

DearSystems

Delighted

Dotykacka

ECB Exchange Rates

Ecwid

Etsy

Eventbrite

Facebook Ads

Faire

Files

Firebase Auth

Firestore

Fishbowl Inventory

Fixer.io

Follow Up Boss

Fortnox

FreshBooks

Freshcaller

Freshsales Classic

Freshsales Suite

Front

Fulfil

Gambio

GitHub

GitLab

Gladly

GoHighLevel

Gong

Google Ads

Google Adwords

Google Analytics 4

Google Play

Google Workspace

Intercom

Invoiced

Iterable

Jira

Jotform

Judge.me

Katana MRP

Keap

Klaviyo

Kustomer

Linear

LiveChat

Looker

MYOB

Mailchimp

MailerLite

Mailgun

Mailjet

Mailshake

Mailstep

Marketplacer

Metronome

Microsoft Dynamics 365 Finance

Microsoft Dynamics On-Premise

Mixpanel

Monday.com

Montapacking

Moosend

Netohq

Notion

Omnisend

Ongoing WMS

Open Exchange Rates

Ordoro

Outreach

PagerDuty

PayPal

Picqer

PostHog

PowerBI

Precoro

Returns a list of tenants that exist in an environment

Retrieve tenants

Disable, enable, and manage schedules across tenants in your environment

Toggle schedule

Name	Value
Platform	Google Sheets
Auth Type	OAuth
Direction	Read
Tap Repo	https://gitlab.com/hotglue/tap-google-sheets
Tap Metrics	Usage:

Getting Started

Key Concepts

Managed authentication

Transformation

Custom Connectors

Unified Schema

Environment Settings

CLI

Connectors

Google Sheets

Connector Details

Getting Started

Key Concepts

Managed authentication

Transformation

Custom Connectors

Unified Schema

Environment Settings

CLI

Connectors

​Connector Details

Connector Details