How Can I Create Google Sheet Triggers with Large Column Data Without Failures?

Help
1

This topic was automatically generated from Slack. You can find the original thread here.

how do i create google sheet triggers with large column data. Triggers with large cell data is getting failed without any errors

2

I understand you’re having issues with Google Sheets triggers when dealing with large column data. To better assist you, can you please provide more details about the specific trigger you’re using and the error message or behavior you’re encountering? This will help me understand the issue and provide a more accurate solution.

3

creating a workflow with “New Updates(Instant)” trigger. when clicking the “create source” button, it loads for a while and then nothing happens. I tried it multiple times. It goes well with all other google sheets

4

Hi , I’ve tried to reproduce your issue. Do you see the error similar to this screenshot?

image.png
image.png3346×1936 290 KB

5

not getting any error. it just loads and nothing happens.

6

could you try to access Pipedream Sources page and create the source there? Maybe you might see the error there

7

getting out of memory error

8

I see, thank you. I will create a ticket for it.

9

Isn’t there a way to fix this now.

10

production server is dependent on it

11

Unfortunately, there’s no immediate workaround that I can think of :pray: Maybe you can setup Pipedream HTTP trigger, then setup an App Script to send HTTP request to Pipedream HTTP Trigger for every update

12

Hi , I’ve added the ticket here: [BUG] Can not create Google Sheet - New Updates source for large sheet · Issue #7494 · PipedreamHQ/pipedream · GitHub