Embedding data from Appsheet app into Google Docs

[aessayyed]

Hello,

Using AppSheet bots, I successfully embedded VARIABLES from a Google sheet into a Google doc.
But I couldn’t find a way to merge the VALUES of those VARIABLES into Google docs or PDF documents, to generate final meaningful documents ready to be printed.
Could you please help?

[Koichi_Tsuji]

We are not sure what VARIABLE you mean in your context.

[Aurelien]

Hi @aessayyed

If you managed at writing <<[yourColumnId]>>, you may want to try <<[yourColumnId].[Name]>>

It could be useful to provide a screenshot of what you try, what you get, and what you expect

[aessayyed]

Sorry, maybe I’m not aware enough of technical expressions. But I mean the ‘Header of a Column’ in a spreadsheet, or the top cell of a column in a spreadsheet.

I also mean by ‘Values’ the data stored in all the cells below the header of a column.

[aessayyed]

Thanks for your great method to guide me.

I received the text as shown in the attached screenshot.

I expected to receive:

Project Titles: Residential Building in Cairo

MF Divisions: 03- Concrete

Activities: Cast-in-Place Concrete Works

But I received:

Project Titles: <<[Project Titles]>>

MF Divisions: <<[MF Divisions]>>

Activities: <<[Activities]>>

[Aurelien]

Hi @aessayyed

what you show looks like a template generated by AppSheet.

It should come here in your bot task:

and the docId is in the URL:

You will need to adapt your template according to your expectations, which means in your case removing the unnecessary informations.

For reference:

https://support.google.com/appsheet/answer/11568965?hl=en

[aessayyed]

Thank you @Aurelien

I did as you recommended (up to my knowledge) , but I received these two alerts in red color:

• Error 1 : Task: ‘Send a Contract email’ Template Type: ‘Attachment’ could not be read due to Value cannot be null. Parameter name: attribute.
• Error 2 : Task: ‘Send a Contract email’ Template Type: ‘Body’ could not be read due to Value cannot be null. Parameter name: attribute.

What else could I make wrong? I used to perform such works using data merged from MS Excel into MS word. There was a ‘Merge’ button and everything is performed correctly.

Thanks for being patient, but I’m trying to learn new things

[Aurelien]

can you provide a screenshot of your app editor error ?

did you type “docId=” before the document ID of your template ?

[aessayyed]

Yes, I did.

[Aurelien]

It looks like the editor don’t get the file you provide.

I’m afraid this is beyond my skills now, you may want to contact Support for this:

https://www.appsheet.com/Support/Contact

[aessayyed]

Thank you @Aurelien for your help and patience.