Generate HTML Table from Google Sheets Data via Webhook

This workflow automates the process of retrieving data from Google Sheets and serving it as an HTML table through a webhook. The main goal is to allow external systems or users to request data in an easy-to-read HTML format, which can be embedded or displayed on web pages.

Here’s how it works step-by-step:

1. **Webhook Trigger**: The workflow starts when it receives an HTTP request through the Webhook node with a specific path. This acts as the trigger for the process.

2. **Read Data from Google Sheets**: Upon receiving the webhook, the workflow fetches data from a designated Google Sheets document, identified by its sheet ID, using the Google Sheets node with OAuth2 credentials.

3. **Build HTML Table**: The retrieved data is then processed by a Function node, which constructs a styled HTML table using Bootstrap. The script dynamically extracts column headers from the data and populates table rows accordingly.

4. **Send HTML Response**: Finally, the generated HTML is sent back as a response to the webhook request, allowing real-time display of Google Sheets data in a clean, structured format.

This workflow can be practical for creating live data dashboards, embedding data tables in website pages, or automating data sharing processes where data visualization in HTML format is required.