Integrate the Google Appsheet API with the Zoho CRM API

Setup the Google Appsheet API trigger to run a workflow which integrates with the Zoho CRM API. Pipedream's integration platform allows you to integrate Google Appsheet and Zoho CRM remarkably fast. Free for developers.

Popular Google Appsheet and Zoho CRM Triggers#

New Contact (Instant) from the Zoho CRM API

Emits an event each time a new contact is created in Zoho CRM

Try it

New Event (Instant) from the Zoho CRM API

Emit new custom events from Zoho CRM

Try it

New Lead (Instant) from the Zoho CRM API

Emits an event each time a new lead is created in Zoho CRM

Try it

New Module Entry (Instant) from the Zoho CRM API

Emit new events each time a new module/record is created in Zoho CRM

Try it

New or Updated Contact (Instant) from the Zoho CRM API

Emits an event each time a new contact is created or updated in Zoho CRM

Try it

Popular Google Appsheet and Zoho CRM Actions#

Convert Lead with the Zoho CRM API

Converts a Lead into a Contact or an Account. See the documentation

Try it

Create Object with the Zoho CRM API

Create a new object/module entry. See the documentation

Try it

Download Attachment with the Zoho CRM API

Downloads an attachment file from Zoho CRM, saves it in the temporary file system and exports the file path for use in a future step.

Try it

Get Object with the Zoho CRM API

Gets record data given its id.

Try it

List Fields with the Zoho CRM API

Gets the field metadata for the specified module

Try it

Overview of Google Appsheet#

The Google Appsheet API enables programmatic interactions with your custom AppSheet applications, allowing you to streamline processes, automate actions, and interlink your apps with other services. Leveraging Pipedream's powerful serverless platform, you can create workflows that react to events in real-time, automate tasks, and connect to countless other services with minimal effort. Whether you're updating datasets, syncing with external systems, or triggering complex chains of actions, combining AppSheet with Pipedream can supercharge your productivity and enhance your app's capabilities.

Connect Google Appsheet#

import { axios } from "@pipedream/platform"
export default defineComponent({
  props: {
    google_appsheet: {
      type: "app",
      app: "google_appsheet",
    }
  },
  async run({steps, $}) {
    const data = {
      "Action": "Find",
      "Properties": `{
          "Locale": "en-US",
          "Selector": "Filter(Sheet1, true)",
          "Timezone":
          "Pacific Standard Time"
      }`,
    }
    return await axios($, {
      method: "post",
      url: `https://api.appsheet.com/api/v2/apps/${this.google_appsheet.$auth.app_id}/tables/{{your_table_here}}/Action`,
      headers: {
        "ApplicationAccessKey": `${this.google_appsheet.$auth.access_key}`,
      },
      data,
    })
  },
})

Overview of Zoho CRM#

The Zoho CRM API enables the manipulation and retrieval of data within Zoho CRM, a platform for managing your sales, marketing, support, and inventory in a single system. Leveraging this on Pipedream, you can automate tasks like syncing contacts, updating lead statuses, or creating custom CRM operations that trigger actions in other apps. Pipedream's serverless platform allows for real-time data processing, transforming, and orchestrating workflows that respond to events in Zoho CRM with minimal latency.

Connect Zoho CRM#

import { axios } from "@pipedream/platform"
export default defineComponent({
  props: {
    zoho_crm: {
      type: "app",
      app: "zoho_crm",
    }
  },
  async run({steps, $}) {
    return await axios($, {
      url: `${this.zoho_crm.$auth.api_domain}/crm/v2/users?type=CurrentUser`,
      headers: {
        "Authorization": `Zoho-oauthtoken ${this.zoho_crm.$auth.oauth_access_token}`,
      },
    })
  },
})