Create Column with Google Sheets API on Cancelled Booking with Customer from Appointedd API

Pipedream makes it easy to connect APIs for Google Sheets, Appointedd and 2,800+ other apps remarkably fast.

Trigger workflow on

Cancelled Booking with Customer from the Appointedd API

Next, do this

Create Column with the Google Sheets API

No credit card required

▶

Watch us build a workflow

8 min

Watch now ➜

Trusted by 1,000,000+ developers from startups to Fortune 500 companies

Developers ♥ Pipedream

Getting Started#

This integration creates a workflow with a Appointedd trigger and Google Sheets action. When you configure and deploy the workflow, it will run on Pipedream's servers 24x7 for free.

Select this integration
Configure the Cancelled Booking with Customer trigger
1. Connect your Appointedd account
2. Configure Polling interval
3. Optional- Select a Customer ID
Configure the Create Column action
1. Connect your Google Sheets account
2. Optional- Select a Drive
3. Select a Spreadsheet ID
4. Select a Worksheet ID
5. Optional- Configure Column Letter
Deploy the workflow
Send a test event to validate your setup
Turn on the trigger

Details#

This integration uses pre-built, source-available components from Pipedream's GitHub repo. These components are developed by Pipedream and the community, and verified and maintained by Pipedream.

To contribute an update to an existing component or create a new component, create a PR on GitHub. If you're new to Pipedream component development, you can start with quickstarts for trigger span and action development, and then review the component API reference.

Trigger#

Cancelled Booking with Customer on Appointedd

Description:Emit new event when a customer cancels an existing group or single booking within your appointedd organisations. [See the documentation](https://developers.appointedd.com/reference/get-bookings)

Version:0.0.1

Key:appointedd-cancelled-booking-with-customer

View on GitHub

Appointedd Overview#

The Appointedd API enables you to manage bookings, resources, services, and customers within the Appointedd platform programmatically. Integrating with Pipedream allows you to automate these tasks, connect with multiple apps, and streamline your scheduling and business workflows. With Pipedream's serverless platform, you can harness Appointedd's capabilities to trigger workflows on specific events, sync data across platforms, or handle complex scheduling logic without writing extensive code.

Trigger Code#

import common from "../common/base-polling.mjs"; import sampleEmit from "./test-event.mjs"; export default { ...common, key: "appointedd-cancelled-booking-with-customer", name: "Cancelled Booking with Customer", description: "Emit new event when a customer cancels an existing group or single booking within your appointedd organisations. [See the documentation](https://developers.appointedd.com/reference/get-bookings)", version: "0.0.1", type: "source", dedupe: "unique", props: { ...common.props, customerId: { propDefinition: [ common.props.appointedd, "customerId", ], }, }, methods: { ...common.methods, getResourceFn() { return this.appointedd.listBookings; }, getParams(lastTs) { return { sort_by: "updated", order_by: "descending", updated_after: lastTs > 0 ? lastTs : undefined, customers: this.customerId, statuses: "cancelled", }; }, getTsField() { return "updated"; }, generateMeta(booking) { return { id: booking.id, summary: `Cancelled Booking with ID ${booking.id}`, ts: Date.parse(booking.updated), }; }, }, sampleEmit, };

Trigger Configuration#

This component may be configured based on the props defined in the component code. Pipedream automatically prompts for input values in the UI and CLI.

Label	Prop	Type	Description
Appointedd	`appointedd`	`app`	This component uses the Appointedd app.
N/A	`db`	`$.service.db`	This component uses `$.service.db` to maintain state between executions.
Polling interval	`timer`	`$.interface.timer`	Pipedream will poll the Trello API on this schedule
Customer ID	`customerId`	`string`	Select a value from the drop down menu.

Trigger Authentication#

Appointedd uses API keys for authentication. When you connect your Appointedd account, Pipedream securely stores the keys so you can easily authenticate to Appointedd APIs in both code and no-code steps.

About Appointedd#

The world’s most flexible online scheduling system.

Action#

Create Column on Google Sheets

Description:Create a new column in a spreadsheet. [See the documentation](https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets.values/batchUpdate)

Version:0.1.13

Key:google_sheets-add-column

View on GitHub

Google Sheets Overview#

The Google Sheets API allows for the creation, reading, updating, and deletion of data within Google Sheets, enabling a robust platform for spreadsheet management and data manipulation. Through Pipedream, you can craft serverless workflows that respond to various triggers, such as webhook events, emails, or scheduled times, to interact with Google Sheets. This synergy can automate reporting, synchronize data across applications, manage inventory, track leads in a CRM, or even conduct survey analysis by updating and retrieving sheet data on the fly.

Action Code#

import googleSheets from "../../google_sheets.app.mjs"; export default { key: "google_sheets-add-column", name: "Create Column", description: "Create a new column in a spreadsheet. [See the documentation](https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets.values/batchUpdate)", version: "0.1.13", annotations: { destructiveHint: false, openWorldHint: true, readOnlyHint: false, }, type: "action", props: { googleSheets, drive: { propDefinition: [ googleSheets, "watchedDrive", ], description: "The drive containing the spreadsheet to edit. If you are connected with any [Google Shared Drives](https://support.google.com/a/users/answer/9310351), you can select it here.", }, sheetId: { propDefinition: [ googleSheets, "sheetID", (c) => ({ driveId: googleSheets.methods.getDriveId(c.drive), }), ], }, worksheetId: { propDefinition: [ googleSheets, "worksheetIDs", (c) => ({ sheetId: c.sheetId, }), ], }, column: { propDefinition: [ googleSheets, "column", ], description: "Insert new column to the RIGHT of this column. Leave blank to insert at start of sheet", optional: true, default: "", }, }, methods: { async getColumnCount() { const sheets = (await this.googleSheets.getSpreadsheet(this.sheetId)).sheets .filter((s) => s.properties.sheetId == this.worksheetId); return sheets[0].properties.gridProperties.columnCount; }, }, async run() { const colIndex = this.googleSheets._getColumnIndex(this.column); const colCount = await this.getColumnCount(); const requests = []; // if inserting a column outside of the grid limits, append to end if (colIndex >= colCount) { requests.push([ { appendDimension: { sheetId: this.worksheetId, dimension: "COLUMNS", length: 1, }, }, ]); } else { requests.push([ { insertRange: { range: { sheetId: this.worksheetId, startColumnIndex: colIndex, endColumnIndex: colIndex + 1, }, shiftDimension: "COLUMNS", }, }, ]); } const request = { spreadsheetId: this.sheetId, requestBody: { requests, }, }; return await this.googleSheets.batchUpdate(request); }, };

Action Configuration#

This component may be configured based on the props defined in the component code. Pipedream automatically prompts for input values in the UI.

Label	Prop	Type	Description
Google Sheets	`googleSheets`	`app`	This component uses the Google Sheets app.
Drive	`drive`	`string`	Select a value from the drop down menu.
Spreadsheet ID	`sheetId`	`string`	Select a value from the drop down menu.
Worksheet ID	`worksheetId`	`integer`	Select a value from the drop down menu.
Column Letter	`column`	`string`	Insert new column to the RIGHT of this column. Leave blank to insert at start of sheet

Action Authentication#

Google Sheets uses OAuth authentication. When you connect your Google Sheets account, Pipedream will open a popup window where you can sign into Google Sheets and grant Pipedream permission to connect to your account. Pipedream securely stores and automatically refreshes the OAuth tokens so you can easily authenticate any Google Sheets API.

Pipedream requests the following authorization scopes when you connect your account:

emailprofilehttps://www.googleapis.com/auth/drive

About Google Sheets#

Use Google Sheets to create and edit online spreadsheets. Get insights together with secure sharing in real-time and from any device.

More Ways to Connect Google Sheets + Appointedd#

Other Popular Integrations#

Add Multiple Rows with Google Sheets API on Cancelled Booking with Customer from Appointedd API

Appointedd + Google Sheets

Create Column with Google Sheets API on Cancelled Booking with Customer from Appointedd API

Pipedream makes it easy to connect APIs for Google Sheets, Appointedd and 2,800+ other apps remarkably fast.

Trusted by 1,000,000+ developers from startups to Fortune 500 companies

Developers ♥ Pipedream

1-24of2,800+apps by most popular

1
-
24
of
2,800+
apps by most popular