Using Google Sheet to Create Google docs

[Thresbin_MoonBlade]

I’ve searched around and cannot find any info on this. It may not be a function yet. I want to use the google sheet watch function to create a new google doc and then save it to Google Drive. The idea is that I’ll add a new row (column a and column b) Then Make will trigger the creation of a google doc and using the info in column A, name the new doc and then save it to the Google Drive.

Currently I can get it to make the doc; however, I cannot get it to use the name in the new row (column A) it keeps naming it H or 2H.

Any advice or guidance would be welcome.

[drnic]

Hey @Thresbin_MoonBlade

The gist of the solution is to use Google Docs “Create a Document From a Template” module:

First, create your template document with {{someFieldName}} wherever you want parameters.

Now, create the “Create a Document From a Template” module, and select this document as your template. Make will automatically discover the {{someFieldName}} text and make it every easy for you to populate it with values from your spreadsheet columns.

In my demo, the values are coming from a Set Variables module:

Save the module, run the scenario, and you should see new documents created:

Here’s my blueprint

Blueprint - Generate proposal from template.json (9.1 KB)

[Thresbin_MoonBlade]

Thank you; however, that’s not quite what I’m looking for. Let me try to explain the workflow and idea better.

I want to start with a google sheet where I can enter information into it. Let’s say I have 25 ideas. I’ll open the google sheet, and on row 2 column A I’ll enter the idea name, on column b I’ll enter some details about the idea.

Then when I run the process. Make will pull the information from Row 2, using column A and create a google doc and name it what I put into column A. It will also put the info into the body of the doc from column b.

The process will repeat every time I run it or when I add a new row of information.

This is just the first step in a full automation workflow I’m building, but if i’m going about this wrong I need to stop now. Thank you for the help.

[drnic]

Your question is: how do I fetch new rows from a Google Sheet that I haven’t previously procsssed, and then use each row as the start of my scenario?

[Thresbin_MoonBlade]

I guess that is a way to phrase it. It’s more specific to the naming of the document being created.

[drnic]

The solution for naming the new Google Doc was in my original screenshots.

Or am I still missing something here?

Perhaps screenshot your Google Sheet and what an example Google Doc would look like for one row of the sheet.

[Thresbin_MoonBlade]

Maybe this will help a little. The Google sheet connects to the Google Doc. The title of the doc to be created should come from the google sheet. Row 2,

[drnic]

Perhaps just try Title: {{1.`0`}} to get the value in column 0 (Book Title)

[drnic]

from spreadsheet that looks like:

You’re using Create a Document instead of Create a Document from Template but I don’t think that changes your ability to name the document.

I think you’re accidentally unnecessarily trying to use get(array...) instead of just pulling in the field you want.

[Thresbin_MoonBlade]

I wish it was so easy. I think the method i’m attempting is not going to work and I’ll need to use the template you proposed at the beginning.

[drnic]

FWIW I was inspired by this to make a video about Google Forms → Sheets → Docs

So thanks for that

[Msquare_Automation]

Hey @Thresbin_MoonBlade

It doesn’t matter which module you are using. The issue is with the mapping. You do not need to use get() function and type array. You need to simply map the “book title” and it should work.

Best regards,

Msquare Automation
Gold Partner of Make
@Msquare_Automation