A.i) Fetch insights data

20 mins to complete

In this tutorial, you will learn how to pull data from Facebook and save it in a spreadsheet using Kitchn.io. If you have any questions about a particular node, click on the node’s name and refer to the node’s documentation.

Facebook uses JSON to work with data. If you are not familiar with JSON, refer to the tutorial.

Video Tutorial

Instructions

1. Add Fetch Facebook Insights node.
2. Add Select Facebook Ad Accounts node. Connect ad_account_ids sockets.
3. Add Map Any to Table Rows node. Connect insights and data sockets and fetched and map triggers. Select Facebook Insight List schema. Choose mapping how you want it in the spreadsheet. Enable the add_header field if you need them.
4. Add Append Google Spreadsheet Rows node.
5. Add Select Google Spreadsheet ID node. Select the suitable spreadsheet. Connect spreadsheet_id and range sockets.
6. Add Clear Google Spreadsheet Rows node if you want to overwrite already existing data. Then, connect spreadsheet_id and range sockets.
7. If you want your data to refresh automatically, use Delay or Delay To nodes.