Exercise 1

<p><strong>Chapter 3/Exercise 1</strong></p><p>This exercise is about using the <em>Google Sheets</em> nodes in conjunction with the <em>Get Request</em> node.</p><p>Retrieve information from the <em>Fake Store API</em> using a <em>GET Request</em>. The <em>Fake Store API</em> is a free online REST API that you can use which contains emulated e-commerce and shopping data.</p><p>Before using the service, obtain the sheet named “Products” from a public Google spreadsheet named “Demo Data”. This sheet needs to be copied inside your own Google Sheets under the email account which you will use for the <em>Google Authenticator</em> node. The sheet can be found here:</p><p><em>https://docs.google.com/spreadsheets/d/1p-Vf46I_KFzkk9dOYCHlC2BH3JY6bEnjKSa4euCiJ1o/edit?usp=sharing</em></p><p>After setting up your <em>Google Sheets Reader</em> node as described in Chapter 3, create an automated workflow to search each product against the <em>Fake Store API</em>, as:</p><p><em>https://fakestoreapi.com/products/category/</em></p>