Pulling data from Gsheets

In this tutorial, you will learn how to pull data from GSheets. This is relevant if you are planning to create ads in bulk from a spreadsheet. Combine this tutorial with any of the tutorials from section D to learn how to create ads from scratch.

Video Tutorial

Instructions

1. Add Select Google Spreadsheet Id node. Choose the tab and the range that you would like to pull in Kitchnware.
2. Add Fetch Google Spreadsheet Rows node. Connect spreadesheet_id and range nodes. Select ROWS as a dimension. Select FORMATTED_VALUE as value_render_option.
3. Add Map Table Rows to Any node. Connect rows sockets. Use Any List as schema. Create the mapping you would need in a JSON object.