Roadmap

Known Bugs

Feature Requests App requests Known Bugs

Voters 2

  • Avatar
  • A
2

Google Sheets Bugs

Avatar
 Richard O'Neill

I am trying to send scraped data to Google Sheets but the formatting is really wonky. I have a few different functions that happen throughout the automation so it keeps trying to send the output from that to Sheets along with the data I actually want. It would be really nice if the "Send to Google Sheets" module worked like the Webhook module where it lets you format the data you are sending.

I tried a workaround where I added a Sheets step, but the insert multiple lines action does not seem to work. No matter how I formatted the inputs, the test always failed, or the Test app button was grayed out and said I had incomplete settings, even though everything was filled.

  • 01-10-2024 -
A

Activity Newest / Oldest

Avatar

Kyle

Status changed to: Closed

Avatar

Kyle

Hey Richard, apologies for being late on this - the formatting when using app steps always expects single items which means if you provide a list, we convert this to a single item with all values.

To export all values to sheets you can use send to Google sheets

To export all data to sheets with custom defining each column you will want to export via webhook to an apps flow which can handle the list version with its “loop” step so that you can iterate over each item

A

David

I have this same issue and since this bug started happening I am unable to trigger any of my automations by creating nor by updating google sheets rows either from apps or TM desktop.