Documents & PDFs
Lido provides action formulas for creating documents from templates, combining and manipulating PDFs, extracting text, and performing OCR.
CREATEPDF
Creates a PDF document from a template.
Syntax:
=CREATEPDF(credential, template_name, output_ref)
=CREATEPDF(credential, template_name, output_ref, content, template_data, make_public, destination)
Parameters:
| Parameter | Description | Required |
|---|---|---|
credential | Document service credential ID | Yes |
template_name | Name of the template to use | Yes |
output_ref | Cell reference to write the output URL | Yes |
content | Content to populate the template | No |
template_data | Template variable values | No |
make_public | Whether the output file should be publicly accessible | No |
destination | Destination folder for the output file | No |
CREATEGOOGLEDOC
Creates a Google Doc from a template. Same parameters as CREATEPDF.
CREATEGOOGLESLIDE
Creates a Google Slides presentation from a template. Same parameters as CREATEPDF.
CREATEGOOGLESHEET
Creates a new Google Sheet.
Syntax:
=CREATEGOOGLESHEET(credential, file_name, output_ref)
=CREATEGOOGLESHEET(credential, file_name, output_ref, content, sheet_name, make_public, destination)
Parameters:
| Parameter | Description | Required |
|---|---|---|
credential | Google credential ID | Yes |
file_name | Name for the new spreadsheet | Yes |
output_ref | Cell reference to write the output URL | Yes |
content | Data to populate the sheet | No |
sheet_name | Name for the worksheet tab | No |
make_public | Whether the file should be publicly accessible | No |
destination | Destination folder | No |
APPENDTOGOOGLEDOC
Appends content to an existing Google Doc.
Syntax:
=APPENDTOGOOGLEDOC(credential, url, content)
=APPENDTOGOOGLEDOC(credential, url, content, status_ref, prepend)
Parameters:
| Parameter | Description | Required |
|---|---|---|
credential | Google credential ID | Yes |
url | Google Doc URL | Yes |
content | Content to append | Yes |
status_ref | Cell reference to write status | No |
prepend | If true, prepends instead of appends | No |
COMBINEPDFS
Combines multiple PDF files into one.
Syntax:
=COMBINEPDFS(pdf_files, output_ref)
=COMBINEPDFS(pdf_files, output_ref, status_ref)
Parameters:
| Parameter | Description | Required |
|---|---|---|
pdf_files | URLs of the PDF files to combine | Yes |
output_ref | Cell reference to write the output URL | Yes |
status_ref | Cell reference to write status | No |
PICKPAGESFROMPDF
Extracts specific pages from a PDF file.
Syntax:
=PICKPAGESFROMPDF(pdf_file, page_range, output_ref)
=PICKPAGESFROMPDF(pdf_file, page_range, output_ref, status_ref)
Parameters:
| Parameter | Description | Required |
|---|---|---|
pdf_file | URL of the PDF file | Yes |
page_range | Pages to extract (e.g., "1-3,5") | Yes |
output_ref | Cell reference to write the output URL | Yes |
status_ref | Cell reference to write status | No |
RESIZEPDF
Resizes the pages of a PDF file.
Syntax:
=RESIZEPDF(pdf_file, width, height, output_ref)
=RESIZEPDF(pdf_file, width, height, output_ref, status_ref)
Parameters:
| Parameter | Description | Required |
|---|---|---|
pdf_file | URL of the PDF file | Yes |
width | New page width | Yes |
height | New page height | Yes |
output_ref | Cell reference to write the output URL | Yes |
status_ref | Cell reference to write status | No |
GETPDFNUMBEROFPAGES
Returns the number of pages in a PDF file.
Syntax:
=GETPDFNUMBEROFPAGES(pdf_file, output_ref)
=GETPDFNUMBEROFPAGES(pdf_file, output_ref, status_ref)
Parameters:
| Parameter | Description | Required |
|---|---|---|
pdf_file | URL of the PDF file | Yes |
output_ref | Cell reference to write the page count | Yes |
status_ref | Cell reference to write status | No |
EXTRACTTEXT
Extracts text content from a PDF file.
Syntax:
=EXTRACTTEXT(pdf_file, output_ref)
=EXTRACTTEXT(pdf_file, output_ref, status_ref)
Parameters:
| Parameter | Description | Required |
|---|---|---|
pdf_file | URL of the PDF file | Yes |
output_ref | Cell reference to write the extracted text | Yes |
status_ref | Cell reference to write status | No |
EXTRACTTABLESFROMPDF
Extracts tables from a PDF file.
Syntax:
=EXTRACTTABLESFROMPDF(pdf_file, output_ref)
=EXTRACTTABLESFROMPDF(pdf_file, output_ref, status_ref)
Parameters:
| Parameter | Description | Required |
|---|---|---|
pdf_file | URL of the PDF file | Yes |
output_ref | Cell reference to write the extracted tables | Yes |
status_ref | Cell reference to write status | No |
IMPORTPDF
Imports PDF content into the spreadsheet.
Syntax:
=IMPORTPDF(pdf_file, output_ref)
=IMPORTPDF(pdf_file, output_ref, status_ref)
Parameters:
| Parameter | Description | Required |
|---|---|---|
pdf_file | URL of the PDF file | Yes |
output_ref | Cell reference to write the content | Yes |
status_ref | Cell reference to write status | No |
OCRMYPDF
Performs OCR on a scanned PDF to make it searchable.
Syntax:
=OCRMYPDF(pdf_file, language, output_ref)
=OCRMYPDF(pdf_file, language, output_ref, status_ref)
Parameters:
| Parameter | Description | Required |
|---|---|---|
pdf_file | URL of the PDF file | Yes |
language | OCR language (e.g., "eng") | Yes |
output_ref | Cell reference to write the output URL | Yes |
status_ref | Cell reference to write status | No |