:hedgehog: PostHog is the leading platform for building self-driving products. Our developer tools – AI observability, analytics, session replay, flags, experiments, error tracking, logs, and more – capture all the context agents need to diagnose problems, uncover opportunities, and ship fixes. Steer it all from Slack, web, desktop, or the MCP.
Python ab-testingai-analyticsanalyticscdpdata-warehouseexperimentsfeature-flagsjavascriptproduct-analyticspythonreactsession-replaysurveystypescriptweb-analytics
import { HogFunctionTemplate } from '~/cdp/types'
export const template: HogFunctionTemplate = {
free: false,
status: 'hidden',
type: 'destination',
id: 'template-google-sheets',
name: 'Google Sheets',
description: 'Update a Google Sheet with the incoming event data',
icon_url: '/static/services/google-sheets.svg',
category: ['Custom'],
code_language: 'hog',
code: `
let res := fetch(f'https://sheets.googleapis.com/v4/spreadsheets/{inputs.spreadsheet_id}/values:batchUpdate', {
'method': 'POST',
'headers': {
'Content-Type': 'application/json',
'Authorization': f'Bearer {inputs.oauth.access_token}'
},
'body': {
'data': {
'range': f'{inputs.spreadsheet_name}!A1:A',
'values': [keys(inputs.fields)]
},
'valueInputOption': inputs.data_format
}
})
if (res.status >= 400) {
throw Error(f'Error from sheets.googleapis.com (status {res.status}): {res.body}')
}
res := fetch(f'https://sheets.googleapis.com/v4/spreadsheets/{inputs.spreadsheet_id}/values/{inputs.spreadsheet_name}:append?valueInputOption={inputs.data_format}', {
'method': 'POST',
'headers': {
'Content-Type': 'application/json',
'Authorization': f'Bearer {inputs.oauth.access_token}'
},
'body': {
'values': [values(inputs.fields)]
}
})
if (res.status >= 400) {
throw Error(f'Error from sheets.googleapis.com (status {res.status}): {res.body}')
}
`,
inputs_schema: [
{
key: 'oauth',
type: 'integration',
integration: 'google-sheets',
label: 'Google Sheets account',
requiredScopes:
'https://www.googleapis.com/auth/spreadsheets https://www.googleapis.com/auth/userinfo.email',
secret: false,
required: true,
},
{
key: 'spreadsheet_id',
type: 'string',
label: 'Spreadsheet ID',
secret: false,
required: true,
description:
'The ID of the Google Sheet to update. In case of https://docs.google.com/spreadsheets/d/17EdJJMxC0ovhCqpSxK4oksVO-MNlL5U0gHn7vqxkXZE/edit?gid=0#gid=0, the ID is `17EdJJMxC0ovhCqpSxK4oksVO-MNlL5U0gHn7vqxkXZE`',
},
{
key: 'spreadsheet_name',
type: 'string',
label: 'Spreadsheet Name',
secret: false,
required: true,
description: 'The name of the sheet/tab within the spreadsheet',
default: 'Sheet1',
},
{
key: 'data_format',
type: 'choice',
label: 'Data Format',
secret: false,
choices: [
{
label: 'RAW - The values the user has entered will not be parsed and will be stored as-is.',
value: 'RAW',
},
{
label: 'USER_ENTERED - The values will be parsed as if the user typed them into the UI, following the same rules that are applied when entering text into a cell via the Google Sheets UI.',
value: 'USER_ENTERED',
},
],
default: 'RAW',
required: false,
description: 'How the input data should be interpreted.',
},
{
key: 'fields',
type: 'dictionary',
label: 'Fields',
secret: false,
required: true,
default: {
timestamp: '{event.timestamp}',
event_name: '{event.event}',
},
description: 'Dictionary defining the fields to be written to the sheet.',
},
],
}