problem connecting google sheet

šŸ¤ Community Show & Tell
1

I created a workflow that extracts data from a PDF and then stores it in a JSON file using this syntax (is generated by the AI parser):

data:"```json
{
"First Name": "Paolo",
"Last Name": "Tane",
"Categoria Merceologica": "Servizi",
"Compagnia Attuale": "Ca"
}

I would then like to save the data into a connected Google Sheet, but I think Iā€™m doing something wrong.

The function that generates the JSON is called makedata, so I set values to append as follows:

[ { "Contact Owner": makedata.data["Contact owner"] } ]

But I keep getting an error. What do you think the issue could be?"

2

Hey Exemi,

If I understand correctly you are using the Google Sheets Resource query and you are updating a sheet? I think if you use the following under "update value" it should work:

{
"First Name": makedata.data["First Name"],
"Last Name": makedata.data["Last Name"],
"Categoria Merceologica": makedata.data["Categoria Merceologica"],
"Compagnia Attuale": makedata.data["Compagnia Attuale"]
}

This is also assuming that you structured your columns like I did in the example. I haven't really used Sheets myself as of yet so I could be wrong. :slight_smile:

3

i have faced this types of issue same can someone help me to solve this problem

4

Hey @willsmith,

Did the above not work for you? What exactly is your problem? If you could give more context/screenshots we might be able to find the problem :slight_smile: