I just created a zap to send post data to google sheets for every new published post. When creating the zap, all test worked and the test zap sent through correctly. However, when I tested it myself by creating a new post in wordpress, nothing was sent to google sheets. There is also nothing in the zap error log and nothing in the task history. I’m not really sure how to troubleshoot this since no errors are showing and the tests worked. Any suggestions on how to investigate this?
Best answer by mmaccou
I figured this out so I’ll answer it myself in case anyone else has this issue. Google was blocking the permissions I gave Zapier until I confirmed it via the email they sent me. If you have this issue...check your email.