Connect Google BigTable and Notion pages in our serverless environment

class GoogleBigtableSourceGetRows {
    async init() {
        // More info at https://www.npmjs.com/package/@google-cloud/bigtable
        // TODO: Create team variables. More info at https://yepcode.io/docs/processes/team-variables
        this.googleBigTable = new Bigtable({
            projectId: yepcode.env.GOOGLE_BIGTABLE_PROJECT_ID,
            credentials: JSON.parse(yepcode.env.GOOGLE_BIGTABLE_SERVICE_ACCOUNT_JSON),
        });
        // TODO: Customize your instance and table names
        this.table = await this.googleBigTable
            .instance("your-instance-name")
            .table("your-table-name");
    }

    async fetch(publish, done) {
        // You can customize get options. eg: get matching keys
        // Look at: https://cloud.google.com/nodejs/docs/reference/bigtable/latest/bigtable/getrowsoptions
        const getRowsOptions = {};
        const [rows] = await this.table.getRows(getRowsOptions);

        for (const rowResponse of rows) {
            const [row] = await rowResponse.get();
            const item = this._mapRowToItem(row);
            await publish(item);
        }
        done();
    }

    _mapRowToItem(row) {
        const columnsAndLastValue = Object.entries(row.data).map(
            ([columnName, columnContent]) => [
                columnName,
                this._getLastColumnValue(columnContent),
            ]
        );
        return Object.fromEntries(columnsAndLastValue);
    }

    _getLastColumnValue(columnContent) {
        // The second [0] is to access the last value
        // You can access previous values by accessing the next
        // elements in the list
        return columnContent[0][0].value;
    }

    async close() {}
}

class NotionTargetCreatePage {
    async init() {
        // More info at https://www.npmjs.com/package/@not  ionhq/client
        // TODO: Create team variables. More info at https://yepcode.io/docs/processes/team-variables
        this.notion = new Client({
            auth: yepcode.env.NOTION_TOKEN,
        });
    }

    async consume(item) {
        // TODO: Customize your page content
        // You may want to check the official docs:
        // https://developers.notion.com/reference/post-page

        // TODO: Customize your database id
        const databaseId = "your-notion-database-id";
        await this.notion.pages.create({
            parent: {
                database_id: databaseId
            },
            icon: {
                type: "emoji",
                emoji: "🥬",
            },
            cover: {
                type: "external",
                external: {
                    url: item.url
                },
            },
            properties: {
                Name: {
                    title: [{
                        text: {
                            content: item.name,
                        },
                    }, ],
                },
                Description: {
                    rich_text: [{
                        text: {
                            content: item.description,
                        },
                    }, ],
                },
                Price: {
                    number: item.price,
                },
            },
            children: [{
                object: "block",
                type: "paragraph",
                paragraph: {
                    rich_text: [{
                        type: "text",
                        text: {
                            content: item.longDescription,
                            link: {
                                url: item.url
                            },
                        },
                    }, ],
                },
            }, ],
        });
    }

    async close() {}
}