Integrate the SheetDB API with the Supabase API

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

Popular Ways to Connect SheetDB with Supabase#

Create Rows with SheetDB API on New Row Added from Supabase API

Supabase + SheetDB

Try it

Create Rows with SheetDB API on New Webhook Event (Instant) from Supabase API

Supabase + SheetDB

Try it

Delete Rows with SheetDB API on New Row Added from Supabase API

Supabase + SheetDB

Try it

Delete Rows with SheetDB API on New Webhook Event (Instant) from Supabase API

Supabase + SheetDB

Try it

Get Column Names with SheetDB API on New Row Added from Supabase API

Supabase + SheetDB

Try it

Popular SheetDB and Supabase Triggers#

New Row Added from the Supabase API

Emit new event for every new row added in a table. See documentation here

Try it

New Webhook Event (Instant) from the Supabase API

Emit new event for every insert, update, or delete operation in a table. This source requires user configuration using the Supabase website. More information in the README. Also see documentation here

Try it

Popular SheetDB and Supabase Actions#

Create Rows with the SheetDB API

Create rows in a Google Sheet using the SheetDB API. See the documentation

Try it

Delete Row with the Supabase API

Deletes row(s) in a database. See the docs here

Try it

Delete Rows with the SheetDB API

Deletes the specified row(s) in a SheetDB sheet by matching a column name and value. See the documentation

Try it

Insert Row with the Supabase API

Inserts a new row into a database. See the docs here

Try it

Get Column Names with the SheetDB API

Get column names of a Google Sheet using the SheetDB API. See the documentation

Try it

Overview of SheetDB#

SheetDB API turns your Google Sheets into a JSON API, enabling you to manage the content within your spreadsheet through RESTful endpoints. With Pipedream, you can harness this capability to build robust automations and workflows that interact with your spreadsheet data dynamically. Whether you're updating rows based on external triggers, syncing data to other platforms, or building a makeshift CRM, SheetDB paired with Pipedream's zero-management execution environment lets you deploy these solutions rapidly.

Connect SheetDB#

import { axios } from "@pipedream/platform"
export default defineComponent({
  props: {
    sheetdb: {
      type: "app",
      app: "sheetdb",
    }
  },
  async run({steps, $}) {
    return await axios($, {
      url: `https://sheetdb.io/api/v1/${this.sheetdb.$auth.api_id}`,
    })
  },
})

Overview of Supabase#

Supabase is a real-time backend-as-a-service that provides developers with a suite of tools to quickly build and scale their applications. It offers database storage, authentication, instant APIs, and real-time subscriptions. With the Supabase API, you can perform CRUD operations on your database, manage users, and listen to database changes in real time. When integrated with Pipedream, you can automate workflows that react to these database events, synchronize data across multiple services, or streamline user management processes.

Connect Supabase#

import { axios } from "@pipedream/platform"
export default defineComponent({
  props: {
    supabase: {
      type: "app",
      app: "supabase",
    }
  },
  async run({steps, $}) {
    return await axios($, {
      url: `https://${this.supabase.$auth.subdomain}.supabase.co/rest/v1/`,
      headers: {
        Authorization: `Bearer ${this.supabase.$auth.service_key}`,
        "apikey": `${this.supabase.$auth.service_key}`,
      },
    })
  },
})