Skip to main content
Question

Making a copy of a google spreadsheet on google drive

  • June 17, 2020
  • 2 replies
  • 89 views
mackenziebudda
Participant
Forum|alt.badge.img+5

I have a google spreadsheet template located on my google drive that I want to make a copy of and move to another folder in Google Drive. The drive connector doesn't allow me to copy or download gsheets.

I was able to have a gsheet reader and writer create a copy of the original spreadsheet however the styling isn't preserved...

 

Does anybody have a work around for copying googlesheets and preserving styling?

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

2 replies

redgeographics
Celebrity
Forum|alt.badge.img+62

You can try the HTTPCaller to send a call to the Google Sheets API: https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets.sheets/copyTo

 

 

FME rocks! \m/
hoa_le
Contributor
Forum|alt.badge.img+5
  • hoa_leContributor
  • Contributor
  • March 23, 2021

You can try the HTTPCaller to send a call to the Google Sheets API: https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets.sheets/copyTo

 

 

Could you explain more details? Thank you

Community Stats

32,207
Posts
122,305
Replies
39,891
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.