Is there a way to copy both the actually spreadsheet and the comments contained within that spreadsheet using a Zap?
I’ve tried duplicating the spreadsheet using both the Google Drive Copy File option and the Google Sheets Create Spreadsheet option but the comments don’t come through.
I’m not seeing an option to make this work but we use comments to explain to clients how to complete each column so I’m hoping there’s a way. 
Welcome to the Community,
You’re quite right, those Google Drive and Google Sheets actions don’t have the ability to copy the comments right now. There’s an existing feature request open for Google Drive app to have the ability to copy the comments as well. Which I’ve gone and submitted your vote for so that we can notify you (by email) the minute that becomes possible.
I’m not seeing any existing feature requests for the Google Sheets app to allow comments to be copied as well. So you may want to reach out to our Support team to request that they open up a feature request for that on your behalf.
In the meantime, it looks like there’s an option to copy the comments when making a copy in Google Sheets directly:
Not an ideal workaround I know as it involves manually making a copy of the spreadsheet but would ensure that the comments are definitely copied over. If we discover a better workaround for this in the meantime we’ll be sure to share it with you here!
Thanks,
For now, I think we’re going to create a separate tab in the template file with instructions so that we don’t have to worry about the comments for now. That said, it’s not ideal for our clients to need to go back and for between tabs to for those explanations/instructions.
Hi
We appreciate your understanding, but we guarantee that once the feature request has been added to the app, we will notify you! 
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.