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
- Add Fetch Facebook Insights node.
- Add Select Facebook Ad Accounts node. Connect
ad_account_ids
sockets. - Add Map Any to Table Rows node. Connect
insights
anddata
sockets andfetched
andmap
triggers. SelectFacebook Insight List
schema. Choose mapping how you want it in the spreadsheet. Enable theadd_header
field if you need them. - Add Append Google Spreadsheet Rows node.
- Add Select Google Spreadsheet ID node. Select the suitable spreadsheet. Connect
spreadsheet_id and range
sockets. - Add Clear Google Spreadsheet Rows node if you want to overwrite already existing data. Then, connect
spreadsheet_id and range
sockets. - If you want your data to refresh automatically, use Delay or Delay To nodes.