# Link from Google Sheets to Glide **URL:** \ **Category:** Ask for Help\ **Created:** [February 28, 2024, 11:14am UTC](https://community.glideapps.com/t/link-from-google-sheets-to-glide/71252 "2024-02-28T11:14:14Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Stefania\_Oancea](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/stefania_oancea/32/60457_2.png) [@Stefania\_Oancea](https://community.glideapps.com/u/Stefania_Oancea)\ **Post date:** [February 28, 2024, 11:14am UTC](https://community.glideapps.com/t/link-from-google-sheets-to-glide/71252/1 "2024-02-28T11:14:14Z")
Hello, It is possible to add in Glide a link from Google Sheets which was automatically create with [Make.com](http://Make.com)? ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [February 28, 2024, 4:28pm UTC](https://community.glideapps.com/t/link-from-google-sheets-to-glide/71252/2 "2024-02-28T16:28:34Z")
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? ---
**Author:** ![Stefania\_Oancea](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/stefania_oancea/32/60457_2.png) [@Stefania\_Oancea](https://community.glideapps.com/u/Stefania_Oancea)\ **Post date:** [February 29, 2024, 7:21am UTC](https://community.glideapps.com/t/link-from-google-sheets-to-glide/71252/3 "2024-02-29T07:21:28Z")
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. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [February 29, 2024, 1:09pm UTC](https://community.glideapps.com/t/link-from-google-sheets-to-glide/71252/4 "2024-02-29T13:09:14Z")
Your options are to configure to your Make workflow to either update the google sheet, or update the table through the Glide API. ---
**Author:** ![Himaladin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/himaladin/32/71023_2.png) [@Himaladin](https://community.glideapps.com/u/Himaladin)\ **Post date:** [February 29, 2024, 1:25pm UTC](https://community.glideapps.com/t/link-from-google-sheets-to-glide/71252/5 "2024-02-29T13:25:49Z")
> [@Stefania\_Oancea](#): > > 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. 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. ---
**Author:** ![Stefania\_Oancea](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/stefania_oancea/32/60457_2.png) [@Stefania\_Oancea](https://community.glideapps.com/u/Stefania_Oancea)\ **Post date:** [February 29, 2024, 1:26pm UTC](https://community.glideapps.com/t/link-from-google-sheets-to-glide/71252/6 "2024-02-29T13:26:15Z")
So, you think it is possible to add from Make to Glide the link with Glide Api? ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [February 29, 2024, 1:47pm UTC](https://community.glideapps.com/t/link-from-google-sheets-to-glide/71252/7 "2024-02-29T13:47:44Z")
Yes. Several people already use Make to update data in Glide. > **[Getting Started with the Glide API | Glide Docs](https://www.glideapps.com/docs/essentials/data-sources/getting-started-with-the-glide-api)** > > A guide to working with the Glide Tables Basic API. This may be useful video unless someone has a link to a better tutorial. > [@Use the Create JSON Module when using Make+Glide API](https://community.glideapps.com/t/use-the-create-json-module-when-using-make-glide-api/58439): > > Hey all! If you’re a regular user of [Make.com](https://www.make.com/en/register?pc=robert) and you’re using it to write to Glide using Glide API, be sure to use the Create JSON module to prevent your Make scenarios from failing. Here’s how: [[Use the Create JSON Module When Calling Glide API Via Make] ](https://www.youtube.com/watch?v=9AMmWDWkAJY) 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. > [@new\_button Updates to the Glide + Make integration](https://community.glideapps.com/t/please-test-make-com-integration/67979): > > Update: We’re aware of some users experiencing issues with Glide + Make. Our engineerings are working on it. If you’re encountering any issues, please add them to this thread. Thank you! pray Otherwise: We’re working on [an improved Make integration](https://www.make.com/en/hq/app-invitation/df4aacc3249174b7dba55ef182d9ecd4) for working with data in Glide Tables. ---
**Author:** ![Stefania\_Oancea](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/stefania_oancea/32/60457_2.png) [@Stefania\_Oancea](https://community.glideapps.com/u/Stefania_Oancea)\ **Post date:** [February 29, 2024, 2:03pm UTC](https://community.glideapps.com/t/link-from-google-sheets-to-glide/71252/8 "2024-02-29T14:03:27Z")
Ok. I will give it a try. Thank you very much! ---
**Author:** ![Stefania\_Oancea](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/stefania_oancea/32/60457_2.png) [@Stefania\_Oancea](https://community.glideapps.com/u/Stefania_Oancea)\ **Post date:** [March 1, 2024, 8:56am UTC](https://community.glideapps.com/t/link-from-google-sheets-to-glide/71252/9 "2024-03-01T08:56:40Z")
![Screenshot 2024-03-01 105359](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/c/8c25a716d52294e693ebedfa579ccb2fd063e04b.png) Can you tell me what to put here at the Value? Is The secret Token? Because I follow all the steps from the video but I don’t know why it doesn’t work… ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [March 1, 2024, 11:10am UTC](https://community.glideapps.com/t/link-from-google-sheets-to-glide/71252/10 "2024-03-01T11:10:18Z")
Yes, for Authorization you need your API Key. It looks like `Bearer .......` ---
**Author:** ![Stefania\_Oancea](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/stefania_oancea/32/60457_2.png) [@Stefania\_Oancea](https://community.glideapps.com/u/Stefania_Oancea)\ **Post date:** [March 1, 2024, 11:15am UTC](https://community.glideapps.com/t/link-from-google-sheets-to-glide/71252/11 "2024-03-01T11:15:39Z")
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. ![Screenshot 2024-03-01 131256](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/7/1754581b6ebee4c3fe9612a09a0fc472a2129c3d.png) ![Screenshot 2024-03-01 131347](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/4/146212127494bf1fadc0bcd780eeb624833a978b.png) ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [March 1, 2024, 11:20am UTC](https://community.glideapps.com/t/link-from-google-sheets-to-glide/71252/12 "2024-03-01T11:20:02Z")
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. ![CleanShot 2024-03-01 at 19.16.27@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/4/a48cbaf1ed13445afeab0ecb8172d468878c83a3.png) ---
**Author:** ![Stefania\_Oancea](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/stefania_oancea/32/60457_2.png) [@Stefania\_Oancea](https://community.glideapps.com/u/Stefania_Oancea)\ **Post date:** [March 1, 2024, 11:52am UTC](https://community.glideapps.com/t/link-from-google-sheets-to-glide/71252/13 "2024-03-01T11:52:50Z")
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:)) ![Screenshot 2024-03-01 135053](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/6/06deb2c074d3e5cd41cf2a85430fa33a45d25ca0.png) ![Screenshot 2024-03-01 135114](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/c/6cee19eeaf9f3d68a6fa6c8f919e71b9dc30a492.png) ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [March 1, 2024, 11:58am UTC](https://community.glideapps.com/t/link-from-google-sheets-to-glide/71252/14 "2024-03-01T11:58:32Z")
Here is your problem 👇 ![CleanShot 2024-03-01 at 19.54.55@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/9/e90889512cd01f0572bf4c22b31bd62c45adf427.png) 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](http://jsonlint.com) and click validate. If it doesn’t report green, then there is something wrong with it. ---
**Author:** ![Stefania\_Oancea](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/stefania_oancea/32/60457_2.png) [@Stefania\_Oancea](https://community.glideapps.com/u/Stefania_Oancea)\ **Post date:** [March 1, 2024, 12:04pm UTC](https://community.glideapps.com/t/link-from-google-sheets-to-glide/71252/15 "2024-03-01T12:04:40Z")
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! ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [March 1, 2024, 12:18pm UTC](https://community.glideapps.com/t/link-from-google-sheets-to-glide/71252/16 "2024-03-01T12:18:20Z")
Paste the entire JSON string here, and I’ll take a look. Please enclose it with triple-backticks ``` That will preserve the formatting. ---
**Author:** ![Stefania\_Oancea](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/stefania_oancea/32/60457_2.png) [@Stefania\_Oancea](https://community.glideapps.com/u/Stefania_Oancea)\ **Post date:** [March 1, 2024, 12:25pm UTC](https://community.glideapps.com/t/link-from-google-sheets-to-glide/71252/18 "2024-03-01T12:25:44Z")
```auto {"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"}}]} ``` ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [March 1, 2024, 12:58pm UTC](https://community.glideapps.com/t/link-from-google-sheets-to-glide/71252/19 "2024-03-01T12:58:33Z")
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: ```auto { "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 👇 ![CleanShot 2024-03-01 at 20.57.14@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/7/87868c4ae46eeb4d0ca8f815ac895cd5fa8f20f6.jpeg) Instead of the above, you should be using the following: ```auto https://api.glideapp.io/api/function/mutateTables ``` Give that a try… ---
**Author:** ![Stefania\_Oancea](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/stefania_oancea/32/60457_2.png) [@Stefania\_Oancea](https://community.glideapps.com/u/Stefania_Oancea)\ **Post date:** [March 1, 2024, 2:33pm UTC](https://community.glideapps.com/t/link-from-google-sheets-to-glide/71252/20 "2024-03-01T14:33:55Z")
It still give me the same error… ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [March 1, 2024, 2:49pm UTC](https://community.glideapps.com/t/link-from-google-sheets-to-glide/71252/21 "2024-03-01T14:49:14Z")
Okay, well just two more things to check: - Add a second header value – `Content-Type` : `application/json` - Double check your Bearer token. Make sure you haven’t copy/pasted it incorrectly, and especially check for any extra spaces before or after. [Next page](https://community.glideapps.com/t/link-from-google-sheets-to-glide/71252.md?page=2)