Connect Supabase and Google Sheets in our serverless environment

class SupabaseSourceSelect {
    async init() {
        // More info at https://www.npmjs.com/package/@supabase/supabase-js
        // TODO: Create team variables. More info at https://yepcode.io/docs/processes/team-variables
        this.supabase = createClient(
            yepcode.env.SUPABASE_URL,
            yepcode.env.SUPABASE_ANON_KEY
        );
    }

    async fetch(publish, done) {
        // TODO: Customize table, columns and filters
        // You may check the full API documentation at:
        // https://supabase.com/docs/reference/javascript/select
        const {
            data,
            error
        } = await this.supabase
            .from("your-table")
            .select("column1, column2")
            .eq("column1", "column-1-filter");
        if (error) {
            throw error;
        }
        for (const row of data) {
            // TODO: map your row to an item
            const item = {
                ...row
            };
            await publish(item);
        }
        done();
    }

    async close() {}
}

class GoogleSpreadsheetTargetCreateSheetRow {
    async init() {
        // More info at https://www.npmjs.com/package/google-spreadsheet
        // TODO: Create team variables. More info at https://yepcode.io/docs/processes/team-variables
        this.googleSpreadsheet = new GoogleSpreadsheet(
            yepcode.env.GOOGLE_SPREADSHEET_ID
        );
        await this.googleSpreadsheet.useServiceAccountAuth(
            JSON.parse(yepcode.env.GOOGLE_SPREADSHEET_SERVICE_ACCOUNT_JSON)
        );
        // TODO: customize your sheet title and header values
        this.sheet = await this.googleSpreadsheet.addSheet({
            title: "your-sheet-title",
            headerValues: ["id", "name"],
        });
    }

    async consume(item) {
        // TODO: Customize the content of each row with your item content
        return this.sheet.addRow({
            id: item.id,
            name: item.name,
        }, {
            insert: true,
        });
    }

    async close() {}
}