Send data from one google sheet to another via webhook POST, GET (HTTP requests)
Budget: $10 – $20 USD
Hi, I have two Google spreadsheets in two different books. On the first sheet: "Source sheet". Three users enter information in a form and the form will send the data to the first worksheet (Source).
In this link you can see an example of the form and the sheet where the data is sent, it is only a reference, it has no major relevance for the project.
Automated Data Entry Form – Google Sheet: https://thedatalabs.org/automated-data-entry-form-google-sheet/
This link shows the first Google spreadsheet where the data generated by the two users is received.
Both users enter information on the same sheet (Source). What I need to avoid is that the users see the information that each one generates at the same time that it is concentrated in a single sheet so that I can visualize it (Destiny).
Source sheet:
https://docs.google.com/spreadsheets/d/1RGRs-9RzMTXq-j7G0QZquMgFbbZatVzIFejOdV6pwng/edit?usp=sharing
The solution I have in mind is that every time a new row is inserted in sheet one (Source) of the first book, it is sent via webhook to the second sheet of the second book (Destiny).
After sending the information via webhook a to the destination sheet (Destiny), the row inserted in the first sheet (Source) must be deleted.
Destination sheet:
https://docs.google.com/spreadsheets/d/1QbjyEhXsjHOJQnGszv86DeXhpwx9SPf7u6trZ3Yau4g/edit#gid=0
In this link you can see an example of the form and the sheet where the data is sent, it is only a reference, it has no major relevance for the project.
Automated Data Entry Form – Google Sheet: https://thedatalabs.org/automated-data-entry-form-google-sheet/
This link shows the first Google spreadsheet where the data generated by the two users is received.
Both users enter information on the same sheet (Source). What I need to avoid is that the users see the information that each one generates at the same time that it is concentrated in a single sheet so that I can visualize it (Destiny).
Source sheet:
https://docs.google.com/spreadsheets/d/1RGRs-9RzMTXq-j7G0QZquMgFbbZatVzIFejOdV6pwng/edit?usp=sharing
The solution I have in mind is that every time a new row is inserted in sheet one (Source) of the first book, it is sent via webhook to the second sheet of the second book (Destiny).
After sending the information via webhook a to the destination sheet (Destiny), the row inserted in the first sheet (Source) must be deleted.
Destination sheet:
https://docs.google.com/spreadsheets/d/1QbjyEhXsjHOJQnGszv86DeXhpwx9SPf7u6trZ3Yau4g/edit#gid=0