Gigasheet

The big data spreadsheet that combines database power with cloud scale.

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.

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

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
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

With the Data Stores API, you can build applications that:

  • Store data for later retrieval
  • Retrieve data from a store
  • Update data in a store
  • Delete data from a store

Connect Data Stores

1
2
3
4
5
6
7
8
9
10
11
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")
  },
})