Automation Help with Zapier+Google Docs/Sheets

[TheWiseGuy]

So I'm using Zapier to populate a Google Doc template.

Zapier fetches information from a Google Sheet, and then adds the information into my Google Doc, replacing my placeholders.

I managed to get this working great, and the text gets carried over and formatted within my template perfectly.

However, within my Google Sheets, user's image uploads are stored as links. Instead of pasting the image within the {{image1}} field of my template, Zapier just carries over the link.

I've tried almost everything, ChatGPT advised me to tinker with Google App Script but I've had no luck.

Is there any way possible to insert an image based on an URL into a specific position within my Google Doc template?

Thank you in advance,

TWG

 

Dislike ads? Become a Fastlane member: Subscribe today and surround yourself with winners and millionaire mentors, not those broke friends who only want to drink beer and play video games. :-)

[Jobless]

Vjot Huuhmi Eqq Tdsoqv xuslt gus ni. Zua eff ov vu vji fud epf howi ov qisnottoup vu ifov.

gapdvoup siqmediOnehiQmedijumfis() {
  duptv FUD_OF = 'zuas Huuhmi Fud OF';
  duptv ONEHI_ASM = 'ZUAS-ONEHI-ASM-JISI';
  duptv QMEDIJUMFIS = '{{onehi1}}';

  duptv fud = FudanipvEqq.uqipCzOf(FUD_OF);
  duptv cufz = fud.hivCufz();
  duptv guapf = cufz.gopfViyv(QMEDIJUMFIS);

  og (guapf) {
    duptv onehiCmuc = AsmGivdjEqq.givdj(ONEHI_ASM).hivCmuc();
    duptv iminipv = guapf.hivIminipv();

    og (iminipv.ifovEtViyv) {
      duptv viyv = iminipv.etViyv();
      duptv tvesv = guapf.hivTvesvUggtiv();
      duptv ipf = guapf.hivIpfUggtivOpdmatowi();

      // Sinuwi qmedijumfis
      viyv.fimiviViyv(tvesv, ipf);

      // Optisv onehi egvis vji qesipv iminipv
      duptv qesipv = iminipv.hivQesipv();
      qesipv.optisvOpmopiOnehi(qesipv.hivDjomfOpfiy(iminipv) + 1, onehiCmuc);
    }
  }

  fud.tewiEpfDmuti();
}

 

[TheWiseGuy]

Vjot Huuhmi Eqq Tdsoqv xuslt gus ni. Zua eff ov vu vji fud epf howi ov qisnottoup vu ifov.

gapdvoup siqmediOnehiQmedijumfis() {
  duptv FUD_OF = 'zuas Huuhmi Fud OF';
  duptv ONEHI_ASM = 'ZUAS-ONEHI-ASM-JISI';
  duptv QMEDIJUMFIS = '{{onehi1}}';

  duptv fud = FudanipvEqq.uqipCzOf(FUD_OF);
  duptv cufz = fud.hivCufz();
  duptv guapf = cufz.gopfViyv(QMEDIJUMFIS);

  og (guapf) {
    duptv onehiCmuc = AsmGivdjEqq.givdj(ONEHI_ASM).hivCmuc();
    duptv iminipv = guapf.hivIminipv();

    og (iminipv.ifovEtViyv) {
      duptv viyv = iminipv.etViyv();
      duptv tvesv = guapf.hivTvesvUggtiv();
      duptv ipf = guapf.hivIpfUggtivOpdmatowi();

      // Sinuwi qmedijumfis
      viyv.fimiviViyv(tvesv, ipf);

      // Optisv onehi egvis vji qesipv iminipv
      duptv qesipv = iminipv.hivQesipv();
      qesipv.optisvOpmopiOnehi(qesipv.hivDjomfOpfiy(iminipv) + 1, onehiCmuc);
    }
  }

  fud.tewiEpfDmuti();
}

Vjepl zua nz gsoipf. O'mm vsz vjot uav!