How to pass data to another sheet in Google Sheets spreadsheet?

Question

This post has been edited by a moderator to remove personal information. Please remember that this is a public forum and to remove any sensitive information prior to posting.How do I pass my data from the botpress sheet to sheet 1, they helped me configure my google sheet but the other person's data is there and not mine, how do I do it because I'm having problems  botpress sheet : when I give it trigger I get this and my data does not appear, they only appear from the other person  Is there a way to change it, good to have more context by synchronizing it with botprees and understanding that it is a single url per workspace until I create another template, I don't know yet.

SamB · Accepted Answer

Hi @Joseph79, welcome to the Community!In order to change the test data in the webhook trigger you’d need to perform the same action in Botpress that would send the webhook. For example that might be creating a new message or conversation in Botpress. Then you’d head back to the Zap and press the Find new records button on the Test section of the Zap’s trigger step:You can find out more about how to do that here:Change the test record in your Zap triggerOnce you’ve got a new test record pulled into the Zap, you’d then head over to the Create Spreadsheet Row action of the Zap. And in the Worksheet field make sure that the Hoja 1 worksheet is selected. That will ensure that whenever Botpress sends a webhook through to the Zap, it will then add the data to the Hoja 1 worksheet rather than the botpress worksheet.Hope that helps. If I’ve misunderstood what you’re trying to do here or you run into any issues on that please let us know! 🙂

Troy Tessalone · Answer

Hi @Joseph79Good question.You’ll need to have new data sent to the Zap webhook trigger, then you can use the [Find new records] button to pull thru new examples to use to configure the Zap action step.

Sign up

Use your Zapier credentials

Log in to the Community

Use your Zapier credentials

Scanning file for viruses.

This file cannot be downloaded