I changed my Square → Google Sheets Zap to connect to a new Google Sheet. I went through all the testing a few times, and made sure to turn the zap off during adjustments.
Even though all of my test zaps are going to the new (correct) sheet, when real time zaps go through they are still going to the old sheet!
I read through the Zappier/Google Sheets guide and I am following all the steps correctly.
Hi
Make sure you published the changes.
We would need to see detailed screenshots with how your Zap steps are configured in the Zap Editor VIEW mode to have full context.
Haha yes, indeed. I clicked publish a few times. Here are some screenshots. Thanks!
Try publishing the Zap again.
Check your Zap Runs to see the DATA IN/OUT for each Zap step.
https://zapier.com/app/history/
i got it to work! Turns out I had 3 steps and didn’t have the paid version, so it wasn’t publishing properly.
That’s an awesome news
Happy Zapping! 
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.