Skip to main content
Best answer

How can I create a Google Sheet copy from spreadsheet in Google Drive?

  • September 12, 2024
  • 32 replies
  • 213 views

Show first post
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

32 replies

Forum|alt.badge.img+1
  • Author
  • Beginner
  • September 18, 2024

Reselected drive and folder, reset all fields for the step and re-entered them and then implemented the variable title - still got a bad request haha

 


Here’s the current state of my google drive:

 

This is quite the pickle, aye?


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • September 18, 2024

@blazersfan77 

When you retest Zap step 1, it should return new example records, make sure to select the top returned example to test your Zap action steps with that data.


Forum|alt.badge.img+1
  • Author
  • Beginner
  • September 18, 2024

I did! All these tests were ran with this one:

 


Just always gives “Bad Request”


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • September 18, 2024

@blazersfan77 

If you’ve done live Zap Runs, check the Zap Runs history details to see the DATA IN/OUT for a Zap step.

Check the LOGS tab to see the underlying API request/response, which can often contain more details about the error.

Include screenshots for us to have context.


Forum|alt.badge.img+1
  • Author
  • Beginner
  • September 19, 2024

So I published it to do a live test like you mentioned but this time I accidentally selected a different excel test sheet and...it worked? 

 


After seeing this, I tested the one I’ve been using and...it didn’t?

 

 



And then I took the contents of this spreadsheet and just attached it to the end of the first spreadsheet I accidentally used...and it worked?

 

 


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • Answer
  • September 19, 2024

@blazersfan77

Not sure.

Perhaps it was a corrupted files that was not encoded correctly.

I recommend continue to test with other files to determine if that is an exception or the rule.


Forum|alt.badge.img+1
  • Author
  • Beginner
  • September 26, 2024

Yeah, testing so far looks good. Seems to be working Troy :)