How to Arrange JSON Keys in Columns on Google Sheets?

How To
1

Good morning,

I am trying to add data inside a JSON, specifically only the ‘KEY’, into a Google Sheets document. I have managed to do it! However, the data is being added by filling only column A of the Google Sheets, with rows corresponding to the number of values in the JSON.

Is there a way to load the KEYS into the columns of the sheet? In other words, I would like the data to be arranged in the order A1, B1, C1, etc. instead of filling only one column.

I am attaching the blueprint to review the project and a screenshot of the scenario.
blueprint (16).json (216.2 KB)

image
image862×231 20.4 KB

Thank you very much.

2

Hello, I would appreciate it if you could also provide screenshots of each module settings (fields).

To allow others to assist you with your scenario, please provide the following:

1. Relevant Screenshots

Could you please share screenshots of your scenario? Also include screenshots of any error messages, module configuration fields, and any filter settings. We need to see what you’re working with to give you the best advice.

You can upload images here using the Upload icon in the text editor:

2. Output Bundles of Modules

Please provide the output bundles of each of the relevant modules by running the scenario (you can also get this without re-running your scenario from the History tab).

Click on the white speech bubbles on the top-right of each module and select “Download input/output bundles”.

490×338 23.5 KB

A. Upload as a Text File

Save each bundle contents in a plain text editor (without formatting) as a bundle.txt file.

You can upload the file here by clicking on this button:

B. Insert as Formatted Code Block

If you are unable to upload files on this forum, alternatively you can paste the formatted bundles.
These are the two ways to format text so that it won’t be modified by the forum:

  • Method 1: Type code block manually

    Add three backticks ``` before and after the content/bundle, like this:

    ```
    content goes here
    ```

  • Method 2. Highlight and click the format button in the editor

Providing the input/output bundles will allow others to replicate what is going on in the scenario, especially if there are complex data structures (nested arrays and collections) or if external services are involved.

Sharing these details will make it easier for others to assist you.

3

Sure, This is the file with the outputs of the modules.

SET VARIABLE
[
    {
        "jsonData": "[\n  { \"key\": \"categoria\", \"value\": \"robot aspirapolvere e lavapavimenti\" },\n  { \"key\": \"potenza_aspirazione\", \"value\": \"11000 Pa\" },\n  { \"key\": \"spazzola_laterale_estensibile\", \"value\": \"presente\" },\n  { \"key\": \"spazzola_laterale_sollevabile\", \"value\": \"presente\" },\n  { \"key\": \"pulizia_moci_a_65_gradi\", \"value\": \"presente\" },\n  { \"key\": \"capacità_batteria\", \"value\": \"5200 mAh\" },\n  { \"key\": \"autonomia_batteria\", \"value\": \"194 min\" },\n  { \"key\": \"capacità_sacchetto_polvere\", \"value\": \"3,2 litri\" },\n  { \"key\": \"capacità_contenitore_polvere\", \"value\": \"300 ml\" },\n  { \"key\": \"capacità_serbatoio_acqua\", \"value\": \"80 ml\" },\n  { \"key\": \"altezza_superamento_ostacoli\", \"value\": \"22 mm\" },\n  { \"key\": \"dimensioni_robot\", \"value\": \"350 x 350 x 103,8 mm\" },\n  { \"key\": \"dimensioni_stazione_base\", \"value\": \"340 x 456,7 x 590,5 mm\" },\n  { \"key\": \"funzione_lavapavimenti\", \"value\": \"presente\" },\n  { \"key\": \"sensori_rilevamento_ostacoli\", \"value\": \"presente\" },\n  { \"key\": \"sistema_anti_groviglio\", \"value\": \"presente\" },\n  { \"key\": \"timer_programmabile\", \"value\": \"presente\" },\n  { \"key\": \"filtro_HEPA_lavabile\", \"value\": \"presente\" },\n  { \"key\": \"base_ricarica\", \"value\": \"presente\" },\n  { \"key\": \"compatibilità_app\", \"value\": \"presente\" },\n  { \"key\": \"compatibilità_assistenti_vocali\", \"value\": \"Amazon Alexa, Google Assistant\" }\n]\n​"
    }
]


PARSE JSON
[
    {
        "key": "categoria",
        "value": "robot aspirapolvere e lavapavimenti"
    },
    {
        "key": "potenza_aspirazione",
        "value": "11000 Pa"
    },
    {
        "key": "spazzola_laterale_estensibile",
        "value": "presente"
    },
    {
        "key": "spazzola_laterale_sollevabile",
        "value": "presente"
    },
    {
        "key": "pulizia_moci_a_65_gradi",
        "value": "presente"
    },
    {
        "key": "capacità_batteria",
        "value": "5200 mAh"
    },
    {
        "key": "autonomia_batteria",
        "value": "194 min"
    },
    {
        "key": "capacità_sacchetto_polvere",
        "value": "3,2 litri"
    },
    {
        "key": "capacità_contenitore_polvere",
        "value": "300 ml"
    },
    {
        "key": "capacità_serbatoio_acqua",
        "value": "80 ml"
    },
    {
        "key": "altezza_superamento_ostacoli",
        "value": "22 mm"
    },
    {
        "key": "dimensioni_robot",
        "value": "350 x 350 x 103,8 mm"
    },
    {
        "key": "dimensioni_stazione_base",
        "value": "340 x 456,7 x 590,5 mm"
    },
    {
        "key": "funzione_lavapavimenti",
        "value": "presente"
    },
    {
        "key": "sensori_rilevamento_ostacoli",
        "value": "presente"
    },
    {
        "key": "sistema_anti_groviglio",
        "value": "presente"
    },
    {
        "key": "timer_programmabile",
        "value": "presente"
    },
    {
        "key": "filtro_HEPA_lavabile",
        "value": "presente"
    },
    {
        "key": "base_ricarica",
        "value": "presente"
    },
    {
        "key": "compatibilità_app",
        "value": "presente"
    },
    {
        "key": "compatibilità_assistenti_vocali",
        "value": "Amazon Alexa, Google Assistant"
    }
]

ARRAY AGGREGATOR
[
    {
        "array": [
            {
                "key": "categoria"
            },
            {
                "key": "potenza_aspirazione"
            },
            {
                "key": "spazzola_laterale_estensibile"
            },
            {
                "key": "spazzola_laterale_sollevabile"
            },
            {
                "key": "pulizia_moci_a_65_gradi"
            },
            {
                "key": "capacità_batteria"
            },
            {
                "key": "autonomia_batteria"
            },
            {
                "key": "capacità_sacchetto_polvere"
            },
            {
                "key": "capacità_contenitore_polvere"
            },
            {
                "key": "capacità_serbatoio_acqua"
            },
            {
                "key": "altezza_superamento_ostacoli"
            },
            {
                "key": "dimensioni_robot"
            },
            {
                "key": "dimensioni_stazione_base"
            },
            {
                "key": "funzione_lavapavimenti"
            },
            {
                "key": "sensori_rilevamento_ostacoli"
            },
            {
                "key": "sistema_anti_groviglio"
            },
            {
                "key": "timer_programmabile"
            },
            {
                "key": "filtro_HEPA_lavabile"
            },
            {
                "key": "base_ricarica"
            },
            {
                "key": "compatibilità_app"
            },
            {
                "key": "compatibilità_assistenti_vocali"
            }
        ],
        "__IMTAGGLENGTH__": 21
    }
]

GSHEET - BULK ADD ROW
[
    {
        "spreadsheetId": "XXXXXXXXXXX",
        "updates": {
            "spreadsheetId": "XXXXXXXXXXX",
            "updatedRange": "A1:A21",
            "updatedRows": 21,
            "updatedColumns": 1,
            "updatedCells": 21,
            "rawUpdatedRange": "Foglio1!A1:A21"
        },
        "sheetName": "Foglio1",
        "rowNumber": 1
    }
]
4

@samliew can you help me? Pleaseeee

With the occasion, do you happen to know the way to then import the CSV within Airtable? I would like to create a Google Sheets and then import it into airtable so that the columns are automatically created by Airtable through the import.
If you could help me out that would be great!

Thanks.