Hello,
It is possible to add in Glide a link from Google Sheets which was automatically create with Make.com?
Hello,
It is possible to add in Glide a link from Google Sheets which was automatically create with Make.com?
What do you mean by âlinkâ?
Just a shortcut to open the Google sheet, or do you mean to have a new Google sheet integrated as tables in your app?
I want to put the link in one of the table. For example, I generate a PDF with Make, and I want to put the link of the PDF back in Glide.
Your options are to configure to your Make workflow to either update the google sheet, or update the table through the Glide API.
If you mean to display a Google Sheets table in Glide, you donât need to involve third parties because Google Spreadsheet already has the âPublish to Webâ option, and you can embed it with web embed (PDF). This will be updated every 5 minutes.
So, you think it is possible to add from Make to Glide the link with Glide Api?
Yes. Several people already use Make to update data in Glide.
This may be useful video unless someone has a link to a better tutorial.
There is also a new Glide integration in Make, but itâs still in beta and Iâm not sure of the status of it.
Ok.
I will give it a try.
Thank you very much!
Yes, for Authorization you need your API Key. It looks like Bearer .......
I entered it and it still doesnât work.
This is the scenario, maybe this will help you to understand. I donât understand what doesnât work.
Doesnât work in what way?
When the scenario runs, there will be a log. If any of the modules fail, their will be error messages. You should examine those errors and see what they are telling you. If you donât understand them, share them here and we will help. But we canât help much with âit doesnât workâ, Iâm afraid
By the way, when you see values in black like those shown below, it means that Make is referencing values that no longer exist. So you need to check those and possibly reconfigure them.
When I introduce in Glide, this scenario works perfectly. I mean I donât have errors, but it introduce nothing to Glide. Or I donât know to recognize the errors:))
Here is your problem
Status code 400 means that the API call failed because it was a âBad Requestâ.
This usually means that your JSON payload was malformed.
Copy the JSON string from the Output Bundle 1, and paste it into jsonlint.com and click validate. If it doesnât report green, then there is something wrong with it.
Error: Parse error on line 1:
âappIDâ:"xlgs6X79kDoSrfNF3M
-------^
Expecting âEOFâ, â}â, â,â, â]â, got â:â
I donât understand what this means, can you help me please with some more explanations? Thank you very much!
Paste the entire JSON string here, and Iâll take a look.
Please enclose it with triple-backticks ```
That will preserve the formatting.
{"appID":"xlgs6X79kDoSrfNF3MuE","mutations":[{"kind":"add-row-to-table","tableName":"native-table-MmhYiCaopgv6H58GbI9G","columnValues":{"BqisW":"OANCEA STEFANIA","CejPM":"2024-02-29T22:00:00.000Z","Pqa1v":"https://drive.google.com/file/d/15FkYQJOLm6HTxKFkqWQ9fW2RhpYd3XNa/view?usp=drivesdk","TXgIM":"GENERIC 1","cwNUj":"OANCEA STEFANIA"}}]}
Actually, that JSON is fine. Which I guess is to be expected if you are using a JSON module to create it.
Here is what it looks like when properly formatted:
{
"appID": "xlgs6X79kDoSrfNF3MuE",
"mutations": [
{
"kind": "add-row-to-table",
"tableName": "native-table-MmhYiCaopgv6H58GbI9G",
"columnValues": {
"BqisW": "OANCEA STEFANIA",
"CejPM": "2024-02-29T22:00:00.000Z",
"Pqa1v": "https://drive.google.com/file/d/15FkYQJOLm6HTxKFkqWQ9fW2RhpYd3XNa/view?usp=drivesdk",
"TXgIM": "GENERIC 1",
"cwNUj": "OANCEA STEFANIA"
}
}
]
}
I suspect that when you copy/pasted into jsonlint earlier, you just had some extra characters.
Anyway, that means that the error is elsewhere.
And⌠hah! I see it.
You are using the wrong API endpoint in your HTTP module
Instead of the above, you should be using the following:
https://api.glideapp.io/api/function/mutateTables
Give that a tryâŚ
It still give me the same errorâŚ
Okay, well just two more things to check:
Content-Type
: application/json