Consultation/guidance needed to build a project

Hire a Pro
,
1

Hello!

I’m curious to check if I can get some external help in building my project. The project involves fetching user inputs through a Google Form, designing prompts based on those inputs to generate output (about 20-30 fields) and replace them in a specific layout (as per a template designed on Google Slides).

I am seeking guidance on how to build this further (as I’m getting stuck) in exchange for a small consultation fee.

I’m a solopreneur, and won’t be able to pay hefty amounts, but I can do the heavy-lifting - all I need is some expert guidance on how to get this done.

Thanks in advance! My email ID is - nkgoutham@gmail.com.

2
  1. Potential Solutions and Steps

Google Forms to Google Sheets: Use Google Forms to collect user inputs. The data will be automatically stored in a linked Google Sheets.
Google Apps Script: Write a script in Google Apps Script to:
Fetch Data: Read data from Google Sheets.
Design Prompts: Process and format the data.
Update Google Slides: Use the Slides API to replace placeholders with the data in your template.Example Script Outline:

javascript

Copy code

function updateSlide() {
  var slideId = 'YOUR_SLIDE_ID';
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Sheet1');
  var data = sheet.getRange('A1:B10').getValues(); // Example range

  var presentation = SlidesApp.openById(slideId);
  var slides = presentation.getSlides();

  // Loop through data and replace placeholders in slides
  for (var i = 0; i < slides.length; i++) {
    var slide = slides[i];
    for (var j = 0; j < data.length; j++) {
      var placeholder = data[j][0];
      var value = data[j][1];
      slide.replaceAllText(placeholder, value);
    }
  }
}

Template Design: Ensure your Google Slides template has clear placeholders for data replacement. Use consistent text or markers to indicate where data should go.