Skip to main content
Solved

Delte GoogleSheet sheet with FME

  • January 22, 2023
  • 2 replies
  • 17 views
dor1411993
Contributor
Forum|alt.badge.img+5

Hi!

I have a work process that writes into googlesheete, I get quite a few errors:

Python Exception <ApiError>: API Error 400 INVALID_ARGUMENT: 'This action would increase the number of cells in the workbook above the limit of 10000000 cells.'

I saw what was being done here:

https://community.safe.com/s/article/Known-Issue-Cell-limit-error-when-writing-to-Google-Sheets

What can solve my problem is the ability to delete the sheet by fme..

Is there such a possibility?

Best answer by redgeographics

The Worksheet Handling parameter on the writer feature type has the option to delete (drop) an existing sheet and create a new one, or truncate an existing sheet (remove all rows)

Screenshot 2023-01-23 at 09.50.34

    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+59
    • redgeographicsCelebrity
    • Celebrity
    • 3700 replies
    • Best Answer
    • January 23, 2023

    The Worksheet Handling parameter on the writer feature type has the option to delete (drop) an existing sheet and create a new one, or truncate an existing sheet (remove all rows)

    Screenshot 2023-01-23 at 09.50.34

    FME rocks! \m/
    dor1411993
    Contributor
    Forum|alt.badge.img+5
    • dor1411993Contributor
    • Author
    • Contributor
    • 39 replies
    • January 23, 2023

    Thanks!

    Community Stats

    32,068
    Posts
    121,757
    Replies
    39,692
    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.