I am just starting to use Zapier and am trying to help our Product team by taking the Product Feedback data we get in Pendo Feedback and pipe it into a Google Sheet. I have setup 2 Zaps
- a Zap to insert a new row in the Sheet when a new piece of Pendo Feedback is added in the Pendo system and
- another Zap to update a row of Feedback in the sheet based on the “ID” when it’s status is changed in the Pendo system.
Seeing a few different issues and wanted to see if there was any guidance someone can offer:
- Incoming Feedback data from Pendo
- The Feedback data I am getting from Pendo does not have the ‘Assignee’ field in it. This is critical to us as it tells us who in the Product team is already assigned to work on/triage this feedback request. Is there a way to configure the incoming data structure to have this information?
- The Feedback data I am getting from Pendo has the ‘Product Area’ information in a ‘Groups’ field under “name”. Is it possible to set this up to be a standalone column in the data output from Pendo?
- The Zap that updates the data in the Google sheet based on Feedback ID is not working. I have made changes to how this is setup and even triggered manual state changes in Pendo on Feedback data by changing its status but the Google Sheet wont get updated.
Thanks for any help or guidance in advance!