Extract data from a published google spreadsheet

[Cedric_Debono_Blaze]

Extract data from a published google spreadsheet and use the values in the first column in a dropdown menu to look up the other values in the row.

{note}
This is the original spreadsheet:
public testing - DO NOT DELETE - Google Sheets

{urlload: https://docs.google.com/spreadsheets/d/e/2PACX-1vRg1Cge8IQ6FgknYMrU6ZRRL42JLsHWwNsX5BYWM-r2PnfaN7utkbf_O-VYO9lUpJa0UvNmS8gYaLfi/pub?output=csv; done=(res) -> ["csv"=res]}
{endnote: trim=right}
{if: iserror(csv)}Loading{else}{rows=slice(map(split(csv, "\n"), row -> split(row, ",")), 2); trim=right}

Col 1 value: {formmenu: values={=rows}; itemformatter=(row) -> row[1]; name=col}
Col 2 value: {=col[2]}
Col 3 value: {=col[3]}
Col 4 value: {=col[4]}{endif}

---

P.S. For instructions on how to publish a Google Sheet, please see this thread:

Can I use a list in google sheet for a drop down menu?

Hi, and welcome to the forum! I assume you are asking about dynamically importing a list from a Google Sheet each time a snippet is used, so that the snippet will reflect the most recent contents of sheet. If so this is possible, but requires a few steps. Step 1. Publish the Sheet to Web as CSV First you'll want to publish you Google Sheet. You can do so under the "Publish to web" option under the "File" menu. Make sure to select the "Comma-separated values" setting. [image] …

[Pratik_Shah]

Hi,

I am really interested to know about this. I am trying your snippet but it does not load any data.

Am I doing it wrong?

Also, can I directly extract data from Airtable base and can use the values in snippets any different places?

[Cedric_Debono_Blaze]

Hi @Pratik_Shah,

1. Click on the folder where you've saved the snippet.
2. Click on "Configure" (see image below)
   
3. Enable the connection to "Google Sheets"

That should make the snippet functional

You can read more about connected snippets here:

Connected Snippets Overview

[Pratik_Shah]

Can you help me get this thing work?
This is my airtable sheet having dummy data. I want to automatically extract these data once I write snippet.

I want drop down with list of "Company Name" i.e. with first column. and based on selection, relevant details of selected company shall be used in snippets.

Is this possible?

[Gaurang_Tandon]

Hey Pratik, I think this snippet does exactly what you mention:

Copy of Snippet "Airtable record lister"

UPDATE: Check out our new lightweight spreadsheet "Data Blaze". You can easily write to and read data from Data Blaze into your existing snippets. We support one-click import of Airtable data into Data Blaze. Check out this guide to get started. Grab all record IDs from an airtable base and then select from one of them using a formmenu. This snippet makes a list of all records from a single table in an Airtable base. It is recommended to look at the original snippet for better understanding …

You will need to change the property names but the rest should work as is. Please do experiment with it

[Pratik_Shah]

Thank you Gaurang. I will play with it.