Hi everyone,
When the info arrive from my webhook to my googlesheet the info (name of the caller, date of the call, transcript, ..) arrive at the end of my googlesheet. So each time I want to see a new info I have to scroll down my spreadsheet.
Do you know guys a way to have the info always arrive at the top ?
Thanks in advance from south of France baby !!!
Welcome to the Make community!
You can make a batchUpdate call using the Sheets “Make an API call” module with a “InsertDimensionRequest” to insert row(s) where you want to insert data into.
Unfortunately, Make doesn’t have a module for this particular endpoint yet (batchUpdate with InsertDimensionRequest).
If the external service has a Developer API Reference/Documentation then you should be able to integrate the endpoints in Make using the app’s universal module (Make an API Call) or generic HTTP “Make a request” module.
You can also suggest for it to be made in the Idea exchange. Don’t forget to search for it first, just in case someone already suggested it, so that you don’t end up creating a duplicate.
If you need assistance in setting up the app’s universal module, or the built-in generic HTTP modules, please provide additional information about what you have tried in relation to the external service’s Developer API Reference — how you are setting the connection up, a link to the endpoint are you trying to connect to, and what errors you are encountering.
You can also complete this brand new course/tutorial in the Make Academy on how to use external APIs — API calls with HTTP modules
- API and Endpoints
- Header and body
- Multipart/form-data
- OAuth 2.0
Then,
You can use the Google Sheets “Update a Row” module —
Updates a row.
For more information, see https://www.make.com/en/integrations/google-sheets, and https://www.make.com/en/help/app/google-sheets in the help centre.
Hope this helps! Let me know if there are any further questions or issues.
— @samliew
P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.
Brother,
You’re speaking chinese to me.
I am sure you mean well, but I am beginner and what you’re saying is too high level for me almost discouraging.
Find the solution !
Was pretty simple actually,
I Sorted the rows by a timestamp “date of the call” .
One option for sorting data in Google Sheets is to click the dropdown button on the column you want to use for the sorting criteria.
The dropdown button is shown when the mouse pointer hovers over the column header. Once you click it, a contextual menu will be shown, including options to sort A → Z and Z → A. This option works for dates too.
I still want to know if it’s possible to sort them directly from the webhook so I sent a message to make.com support.
Keep you posted.
2 Likes
thank you for coming back and sharing the solution! This will be very helpful for other Makers with the same issue.
Have a great daaay! 
1 Like