1,666
edits
Use Autocrat with Google Sheets: Difference between revisions
Use Autocrat with Google Sheets (view source)
Revision as of 10:01, 24 January 2023
, 24 January 2023no edit summary
Mvanmierlo (talk | contribs) No edit summary |
Mvanmierlo (talk | contribs) No edit summary |
||
| Line 12: | Line 12: | ||
==How can I use Autocrat with Google Sheets?== | |||
Autocrat is an extension for Google Sheets that helps generate Google Docs or PDFs from existing Google Sheet entries. For example: '''''Mr. V created a Google Form to collect bake sale information, and wanted to create individual PDF files from the Google Form responses.''''' This is a perfect use-case for Autocrat. Autocrat will take the Google Sheet data and use a template Google Doc with placeholders to autogenerate documents and save them to your Google Drive. Autocrat is also capable of sending emails based on form data. Explore the resources below if you would like to learn more about this! | Autocrat is an extension for Google Sheets that helps generate Google Docs or PDFs from existing Google Sheet entries. For example: '''''Mr. V created a Google Form to collect bake sale information, and wanted to create individual PDF files from the Google Form responses.''''' This is a perfect use-case for Autocrat. Autocrat will take the Google Sheet data and use a template Google Doc with placeholders to autogenerate documents and save them to your Google Drive. Autocrat is also capable of sending emails based on form data. Explore the resources below if you would like to learn more about this! | ||
| Line 25: | Line 25: | ||
#See the document(s) in your Google Drive folder, and you are done! | #See the document(s) in your Google Drive folder, and you are done! | ||
==How can I learn to use Autocrat?== | |||
There are many online resources available to learn Autocrat. One that we recommend is the following website which walks you through Autocrat setup and more for simple Google Forms. | There are many online resources available to learn Autocrat. One that we recommend is the following website which walks you through Autocrat setup and more for simple Google Forms. | ||
| Line 32: | Line 32: | ||
Autocrat is a wonderful tool that takes some time to learn, if you have questions about this feel free to reach out to a member of the Tech Team so that we can guide you through setting this up. You can either submit a ticket, come to the Tech Tables in the cafeteria during help desk, or dial x50 on a campus phone. We are here to help! | Autocrat is a wonderful tool that takes some time to learn, if you have questions about this feel free to reach out to a member of the Tech Team so that we can guide you through setting this up. You can either submit a ticket, come to the Tech Tables in the cafeteria during help desk, or dial x50 on a campus phone. We are here to help! | ||
==What are some tips for using Autocrat?== | |||
*In your template, specify placeholders using '''''<< SOME NAME >>'''''. You will map this placeholder to existing column headers in your Google Sheet data source. | *In your template, specify placeholders using '''''<< SOME NAME >>'''''. You will map this placeholder to existing column headers in your Google Sheet data source. | ||