Push Image from Google Sheets to Google Docs

[david]

@Supreme Work flow name: 2_CFO Image Gsheets to GDocs

It says my tasks count are exhausted. Could you help me find out where I have gone wrong? I didn't get the outcome I want that is images over to Google Docs

 

[Supreme]

Hey @david

Again you haven't mentioned the doc name which is not appearing and available in your Google Docs. And it is not possible to pass the image in the Google Sheets with the help of Google Docs action event.

And as we can see you haven't exhausted any of the tasks from your given workflow. Further, you can check your overall task count from your accounts history section.

 

[david]

@Supreme could you kindly help me reset my task count? I am not sure what I did wrong that resulted in exhausted tasks count.

It is possible possible to push Google Sheets to google Docs with Pabbly, I have done it before. It was successful in my tests but I am unabel to execute for all of the rows in Google Sheets. Could you or another colleague more familiar with this help out?

Doc name: Letter Campaign to CFO

 

[Supreme]

Hey @david

We still didn't get your use case and are unable to process into. Though we couldn't find any extra consuming consuming workflow in your account still we have to rest all of your tasks for the last time.

 

[david]

@Supreme I have recorded a video for you to explain in clear terms: https://app.vmaker.com/record/Kv3z36FJoldZK3YM

Thanks for your help!

 

[Supreme]

Hey @david

We tried your workflow at our end and it is working accordingly the image is posted at the top of the page.

Kindly try with a new doc.

 

[david]

@Supreme I tried this and it is successful, but how do I execute for all the 500 images I have in Google sheets without exhausting all my tasks limits?

Hey @david

We tried your workflow at our end and it is working accordingly the image is posted at the top of the page.

Kindly try with a new doc.

View attachment 7330

 

[Supreme]

Hey @david

You can refer to the following video to pass it in bulk.

 

[david]

@Supreme I have watched but it doesn't explain how I can use Send Event or Custom event from Gsheets. How could I use Send Event or Custom Send instead of using Get Rows?

 

[Supreme]

Hey @david

We have designed a workflow according to your use case, it will post all the LinkedIn photos to your Google Docs at once. Please check out the following screenshot and review the workflow in your account.

You can give it a try with 5 or 6 rows of your Google Sheets.

 

[david]

@Supreme 1) how can I do it from Google Sheet Send Event or Custom event? This way I save more tasks. If I use Get Row I will consume more tasks limits. 2) how can I prevent it from going into a loop and consume all of my tasks limits?

 

[Supreme]

Hey @david

how can I do it from Google Sheet Send Event or Custom event? This way I save more tasks. If I use Get Row I will consume more tasks limits.

You can use Send custom data ad-on from the Pabbly Connect extension, to send a limited row at a time manually.

 

[david]

@Supreme

1. What is the max row limits I could send from?
2. What should I do to prevent it going into a loop and consume all of my task limits?

 

[Supreme]

Hey @david

What is the max row limits I could send from?

You send all the rows if you want, but would recommend sending fewer rows at a time. So that your action step wouldn't exhaust the applications' rate limit.

What should I do to prevent it going into a loop and consume all of my task limits?

Check for the same event type in the trigger and in the action step.

 

[david]

@Supreme
There is data found on C2, why does it prompts no data found on row 2?

 

[david]

@Supreme I just click send custom data and selected C2 to C10 but no results to my Google Docs. Why is that?

 

[Supreme]

Hey @david

You have picked the wrong option to send the custom data, you need to check for the "Send Custom data" instead of "Initial setup".

 

[david]

@Supreme I've followed your instructions step by step here: https://app.vmaker.com/record/J2biyw3iXD8yPE4g

Please let me know if I did it correctly? I still not achieve the images that I want in Google Docs.

 

[Supreme]

Hey @david

Please check out the following short recorded video regarding your concern, kindly check that out -

https://www.screenpresso.com/=7cL9e

 

[david]

@Supreme I've followed your instructions but partial success. https://app.vmaker.com/record/6UrNpGvU2J2vWsvC