Integrate the Gigasheet API with the Data Stores API

Setup the Gigasheet API trigger to run a workflow which integrates with the Data Stores API. Pipedream's integration platform allows you to integrate Gigasheet and Data Stores remarkably fast. Free for developers.

Popular Gigasheet and Data Stores Actions#

Create Export with the Gigasheet API

Creates an export for a gigasheet dataset. See the documentation

Try it

Add or update a single record with the Data Stores API

Add or update a single record in your Pipedream Data Store.

Try it

Download Export with the Gigasheet API

Downloads an export from Gigasheet. See the documentation

Try it

Add or update multiple records with the Data Stores API

Add or update multiple records to your Pipedream Data Store.

Try it

Upload Data From URL with the Gigasheet API

Uploads data from a URL to Gigasheet. See the documentation

Try it

Overview of Gigasheet#

The Gigasheet API enables users to manipulate large-scale data sheets within the cloud effortlessly. Through Pipedream, you can leverage this functionality to automate data analysis, manipulation, and enrichment workflows. By connecting Gigasheet with other apps, you can streamline processes like data import, transformation, and sharing, making Pipedream an ideal platform to enhance productivity and data handling efficiency.

Connect Gigasheet#

import { axios } from "@pipedream/platform"
export default defineComponent({
  props: {
    gigasheet: {
      type: "app",
      app: "gigasheet",
    }
  },
  async run({steps, $}) {
    return await axios($, {
      url: `https://api.gigasheet.com/user/whoami`,
      headers: {
        "X-GIGASHEET-TOKEN": `${this.gigasheet.$auth.api_key}`,
        "accept": `application/json`,
      },
    })
  },
})

Overview of Data Stores#

Data Stores are a key-value store that allow you to persist state and share data across workflows. You can perform CRUD operations, enabling dynamic data management within your serverless architecture. Use it to save results from API calls, user inputs, or interim data; then read, update, or enrich this data in subsequent steps or workflows. Data Stores simplify stateful logic and cross-workflow communication, making them ideal for tracking process statuses, aggregating metrics, or serving as a simple configuration store.

Connect Data Stores#

export default defineComponent({
  props: {
    myDataStore: {
      type: "data_store",
    },
  },
  async run({ steps, $ }) {
    await this.myDataStore.set("key_here","Any serializable JSON as the value")
    return await this.myDataStore.get("key_here")
  },
})