Retrieve or Chat with Google Sheets or Airtable Information In An Structured Way

Questions
,
1

Describe the problem/error/question

Wich nodes are the best ones to configure a google sheets workflow in order to look up or retrieve information, and deliver in an structured way output, based on the input prompt?

I saw thus tamplate, but it´s difficult to know wich is the best way to configure.

What is the error message (if any)?

No error, just i don´t know how to solve the problem. hahah!

Please share your workflow

The closest example I’ve seen of what I want, is from a template made it by: @sirdavidoff

@bartv @Jon (Sorry for add you guys, but you are the one who i have seen a lot in posts. hahaha!)

(Select the nodes on your canvas and use the keyboard shortcuts CMD+C/CTRL+C and CMD+V/CTRL+V to copy and paste the workflow.)

Share the output returned by the last node

Information on your n8n setup

  • n8n version:
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system:
2

It looks like your topic is missing some important information. Could you provide the following if applicable.

  • n8n version:
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system:
3

Hey @Emmanuel_Cabrera , if you want a structured output you can enable output parser as shown below. Once enabled you have an addition output for the parser sub-node.

image
image922×1346 89.1 KB