πŸ”¬ Google spreadsheet to HTML - variant with JS function

⚑ 2,536 views Β· πŸ”¬ Document Extraction & Analysis

Description

This workflow shows a low code approach to creating a HTML table based on Google Sheets data. It’s similar to this workflow, but allows fully customizing the HTML output.

image.png

To run the workflow:

  1. Make sure you have a Google Sheet with a header row and some data in it.
  2. Grab your sheet ID: image.png
  3. Add it to the Google Sheets node: image.png
  4. Activate the workflow or execute it manually
  5. Visit the URL provided by the webhook node in your browser (production URL if the workflow is active, test URL if the workflow is executed manually)

πŸ”— Nodes Used

Function, Google Sheets, Start, Webhook

πŸ“₯ Import

Download workflow.json and import into n8n: Workflow menu β†’ Import from File

πŸ“– Importing guide Β· πŸ”‘ Credential setup