Pipedream: Google Sheets -> Supabase

pipedream-gsheets-supabase.js

import { axios } from "@pipedream/platform"
import { createClient } from '@supabase/supabase-js'
import qs from 'qs';
export default defineComponent({
  props: {
    supabase: {
      type: "app",
      app: "supabase",
    }
  },
  async run({steps, $}) {
    if (steps.trigger.event.newRow.length != 2)
      return
    if (steps.trigger.event.newRow[0].length < 10)
      return
    if (steps.trigger.event.newRow[1].length < 2)
      return
    const supabase = createClient(this.supabase.$auth.subdomain, this.supabase.$auth.service_key)
    const { data, error } = await supabase
      .from('suggestions')
      .insert([
        {
          url: steps.trigger.event.newRow[0],
          title: steps.trigger.event.newRow[1]
        }
      ])
  },
})