Navigate to [https://docs.google.com/forms/d/1tRtKbFgJE6nkmGyE-nQmJA87xMNMahGV5B7XvVAonKU/template/preview](https://docs.google.com/forms/d/1tRtKbFgJE6nkmGyE-nQmJA87xMNMahGV5B7XvVAonKU/template/preview)

Click "Create" (Or you can link it to an existing spreadsheet)

Click "Please complete as much or as little as you want. Note which ones you need to complete as full sentences and which ones you don't. If you don't ..."

Please complete as much or as little as you want. Note which ones you need to complete as full sentences and which ones you don't. If you don't write full sentences or paragraphs you will need to edit your final result. When you link this form to a Google Sheet, copy this code =CONCATENATE(B2, CHAR(10), CHAR(10), "I just finished reading ", C2, " by ", D2, ". I read the ", F2, " published by ", E2, ". ", H2, I2, J2, CHAR(10), CHAR(10), "This book is a must read if you like: ", K2, CHAR(10), CHAR(10), L2, CHAR(10), CHAR(10), M2, CHAR(10), CHAR(10), N2, CHAR(10), CHAR(10), O2, CHAR(10), CHAR(10), P2, CHAR(10), CHAR(10), Q2, CHAR(10), CHAR(10), R2, CHAR(10), CHAR(10), S2, CHAR(10), CHAR(10), T2, CHAR(10), CHAR(10), "Content Warnings: ", U2, ".") and past it in cell V2. Then click on cell V2 and copy (you are copying the CELL not the text or code). Then you can highlight the rest of column V and past. It will automatically change the cells it is pulling from so when the spreadsheet fills out it will automatically create the review that is ready to post! If you delete any of the questions you need to delete the correlating cell in the code. 

Copy the formula (this is how the magic happens).

Switch to tab Book Reviews Made Easy (Responses) - Google Sheets"

Double-click into cell W2 (Yes, the picture shows V2, it is an old version)

Now you need to fill in the Google form. Go back to google form.

In a new tab, navigate to the link you copied.

Then fill in all the information for your review.

Newtab

Google Docs is a cloud-based document editing and collaboration platform. Learn how to change your doc margins, delete pages from docs, strikethrough text, and much more.

Google Docs

Google Sheets is a powerful online tool to help you do quantitative analysis. Learn how to use formulas to manipulate and analyze datasets, such as Google Sheets' COUNTIF and SUMIF functions, among many others.

How To Create A Google Form For Book Reviews