Skip to main content
Question

Unable to update rows in Google Sheets after copying from another file

  • November 25, 2025
  • 4 replies
  • 23 views

In my ZAP I’m copying a spreadsheet from original file. As a next step I want to put specific values in spreadsheet rows and columns (eg. put “date” in C2). and finish the ZAP - sounds easy.

 

Unfortunately after creating spreadsheet I can’t refer to it and update rows - Worksheet isn’t working and I can’t pick columns. I was trying both with Google drive google spreadsheet, find file etc. nothing works. 
When I pick static file it works fine.
Please help! 

I have the feeling that at some point in the past it was working or maybe I’m doing something incorrect

 

4 replies

Sparsh from Automation Jinn
Forum|alt.badge.img+6

Hey ​@piotr000999,

Please post screenshots of Data In, Data Out as well how each Zap step is configured for us to have more context.

Try using Creating Worksheet action for creating worksheet.

 

Hope it helps!


  • Author
  • New
  • November 25, 2025

data out from previous step (google drive copy file step:
next step is update row and is not working


 

userPermission

User Permission Kind

drive#permission

User Permission Etag

"zFM4aM8egz4A3GaJODR5ZQrzmF4"

User Permission Id

me

User Permission Self Link

https://www.googleapis.com/drive/v2/files/1IymcpYbIJ4UtwHePRNf8iQ-ph2J5CMUvGFQU-twn8OA/permissions/me

User Permission Role

fileOrganizer

User Permission Type

user

exportLinks

Export Links Application X Vnd Oasis Opendocument Spreadsheet

https://docs.google.com/spreadsheets/export?id=1IymcpYbIJ4UtwHePRNf8iQ-ph2J5CMUvGFQU-twn8OA&exportFormat=ods

Export Links Text Tab Separated Values

https://docs.google.com/spreadsheets/export?id=1IymcpYbIJ4UtwHePRNf8iQ-ph2J5CMUvGFQU-twn8OA&exportFormat=tsv

Export Links Application Pdf

https://docs.google.com/spreadsheets/export?id=1IymcpYbIJ4UtwHePRNf8iQ-ph2J5CMUvGFQU-twn8OA&exportFormat=pdf

Export Links Application Vnd Openxmlformats Officedocument Spreadsheetml Sheet

https://docs.google.com/spreadsheets/export?id=1IymcpYbIJ4UtwHePRNf8iQ-ph2J5CMUvGFQU-twn8OA&exportFormat=xlsx

Export Links Text Csv

https://docs.google.com/spreadsheets/export?id=1IymcpYbIJ4UtwHePRNf8iQ-ph2J5CMUvGFQU-twn8OA&exportFormat=csv

Export Links Application Zip

https://docs.google.com/spreadsheets/export?id=1IymcpYbIJ4UtwHePRNf8iQ-ph2J5CMUvGFQU-twn8OA&exportFormat=zip

Export Links Application Vnd Oasis Opendocument Spreadsheet

https://docs.google.com/spreadsheets/export?id=1IymcpYbIJ4UtwHePRNf8iQ-ph2J5CMUvGFQU-twn8OA&exportFormat=ods

Parents

1

Parents Kind

drive#parentReference

Parents ID

1nf2Y8JlbsRuo086I9oGp62bjzGssnoQz

Parents Self Link

https://www.googleapis.com/drive/v2/files/1IymcpYbIJ4UtwHePRNf8iQ-ph2J5CMUvGFQU-twn8OA/parents/1nf2Y8JlbsRuo086I9oGp62bjzGssnoQz

Parents Parent Link

https://www.googleapis.com/drive/v2/files/1nf2Y8JlbsRuo086I9oGp62bjzGssnoQz

Parents Is Root

false

lastModifyingUser

Last Modifying User Display Name

PXXXXX BXXXXXX

Last Modifying User Kind

drive#user

Last Modifying User Is Authenticated User

true

Last Modifying User Permission Id

09340614387717846531

Last Modifying User Email Address

pxxxx@xxxxxxx.ai

picture

Last Modifying User Picture Url

https://lh3.googleusercontent.com/a/ACg8ocLJ4Gwt2fwtNWHLq0XFTrgHTWZwzy5UhTkAV1PWC9EYU2SWM4Q=s64

Spaces

1

drive

labels

Labels Starred

false

Labels Hidden

false

Labels Trashed

false

Labels Restricted

false

Labels Viewed

true

capabilities

Capabilities Can Copy

true

Capabilities Can Edit

true

Kind

drive#file

ID

1IymcpYbIJ4UtwHePRNf8iQ-ph2J5CMUvGFQU-twn8OA

Etag

"MTc2NDA3MTI5NDAzNA"

Self Link

https://www.googleapis.com/drive/v2/files/1IymcpYbIJ4UtwHePRNf8iQ-ph2J5CMUvGFQU-twn8OA

Alternate Link

https://docs.google.com/spreadsheets/d/1IymcpYbIJ4UtwHePRNf8iQ-ph2J5CMUvGFQU-twn8OA/edit?usp=drivesdk

Embed Link

https://docs.google.com/spreadsheets/d/1IymcpYbIJ4UtwHePRNf8iQ-ph2J5CMUvGFQU-twn8OA/htmlembed?ouid=114419267252517080521

Icon Link

https://drive-thirdparty.googleusercontent.com/16/type/application/vnd.google-apps.spreadsheet

Title

Engineering order BOM: 2025-11-25 | Piotr Brzeski | 3978

Mime Type

application/vnd.google-apps.spreadsheet

Copy Requires Writer Permission

false

Created Date

2025-11-25T11:48:14.034Z

Modified Date

2025-11-25T11:48:14.034Z

Modified By Me Date

2025-11-25T11:48:14.034Z

Last Viewed By Me Date

2025-11-25T11:48:14.034Z

Marked Viewed By Me Date

1970-01-01T00:00:00.000Z

Version

3

File Size

1

Quota Bytes Used

1

Team Drive Id

0AMnZh8Pk-SoqUk9PVA

Drive Id

0AMnZh8Pk-SoqUk9PVA

Last Modifying User Name

PXXXXX BXXXXXX

Editable

true

Copyable

true

Explicitly Trashed

false

App Data Contents

false

This post has been edited by a moderator to remove personally identifiable information (PII). Please remember that this is a public forum and avoid sharing personal or potentially sensitive details.


AndrewJDavison
Forum|alt.badge.img+11
  • Zapier Solution Partner
  • November 25, 2025

@piotr000999 

Just to make sure - the file you copy in step 7, is that a Google Spreadsheet file, or is it an uploaded Excel file? If it’s the latter it won’t work


  • Author
  • New
  • November 25, 2025

Yes this is spreadsheet file. Also tried to use "create spreadsheet" function in zapier but it doesnt work as well