Push Image from Google Sheets to Google Docs

[david]

How can I push the image from Google sheets to Google docs like the image?

Please provide step by step help.

 

[Supreme]

Hey @david

You can refer to our tutorial video for better understanding, rest you can design your document all by yourself. Kindly try this at your end and let us know if you need any further assistance regarding your automation.

(Watch the first two parts of the video)

 

[david]

@Supreme I have watched the video, it does not teach me how to send from Google Sheets image URL to Google Docs and resize it accordingly to the Google Doc

 

[Supreme]

Hey @david

You can check out the following screenshot with the required action steps to achieve your use case.

Google Doc - https://docs.google.com/document/d/1XmDAiouXGc8cUa91uWcnX4ipQUfFYnK3SeZihz3RfUA/edit?usp=sharing

Rest you can design your template by yourself and you need to pass the size(circular, square, etc) of the image as required and the dimension of the image you can decide in the Google Docs: Insert an Image to a Specific Location action event.

 

[david]

@Supreme How can I do it slowly so that it would not reach Google's API limit?

 

[Supreme]

Hey @david

You can add 1 min Delay action step to avoid the rate limits.

 

[david]

@Supreme How can I send just rows from C2 to C105 column and then continue from row C106 the next day? Please provide step by step guide.

 

[Supreme]

Hey @david

Could you please share your use case or the respective workflow in which you wanted to implement this?

Thanks

 

[david]

@Supreme I want the image from C2 to C105 from Gsheets to be here like thi

 

[Supreme]

Hey @david

How can I send just rows from C2 to C105 column and then continue from row C106 the next day? Please provide step by step guide.

Please check out the following screenshot for your concerning use case and for a better understanding please check out the following screenshot.

Kindly try this at your end and let us know if that works for you.

Happy New Year
Regards

 

[david]

@Supreme What I meant is from Google Sheets C2 to C105 send image from Pabbly Connect to Google Docs. How can I do it? (The screen you have povided earlier are for number formatting, which is incorrect?)

 

[Supreme]

Hey @david

We have used the C2:C105 range but you can use the range from C2 to C105 it will work as it is. And which part of the number formatting is incorrect, please let us know.

If you still face any difficulty while building the automation, you can also consult the same with the other automation expert for your concerning use case.

Pabbly Connect Experts and Consultants

If you are a Pabbly Connect expert and can help other customers in building their workflows. Feel free to add your details below. You can mention following details: 1. Your Name: 2. Your Company Name: 3. Contact Email/Any Appointment Scheduling Link: 4. Any expertise area that you want to...

forum.pabbly.com

Thanks

 

[david]

@Supreme Got it so Pabbly Connect doesn't provide guide and support on how to build automation?

 

[david]

@Supreme I want to send image link from cell c2 to c300 to google docs. Which one should I click on? Please provide step by step guide.

How long should the delay be? Please provide step by step guide.

 

[Supreme]

Hey @david

If you are using Google Sheets trigger event and you want a specific range to be forwarded, you can use the "Send Custom" ad-on, where you can decide the "Start Range:" "End Range:" but that would work once.

 

[david]

@Supreme
My start range would be C2:C250, that means it will skip the header row, is that correct?
There are 250 rows, can I run all 250 without Google stopping it?

 

[david]

@Supreme How can I map my Google Sheet to be inserted the image?

 

[Supreme]

Hey @david

My start range would be C2:C250, that means it will skip the header row, is that correct?
There are 250 rows, can I run all 250 without Google stopping it?

Yes, it will skip the header from the range.

How can I map my Google Sheet to be inserted the image?

Could you please elaborate on your query!!

 

[david]

@Supreme How can I select the Google Doc I want? Presently it's not selecting the correct Google Doc

 

[Supreme]

Hey @david

Could you please share the workflow name and the Doc name which is not appearing with the help of a screenshot or a short video?