Step 2: Connect Facebook Auth Inputs

These variables are used by the HTTP requests to obtain and refresh long-lived tokens.

1. Open Assign Auth Variables and set the following fields:
2. Set client_id to [YOUR_ID].
3. Set client_secret to [CONFIGURE_YOUR_API_KEY].
4. Set user_access_token to [CONFIGURE_YOUR_TOKEN].
5. Set app_scoped_user_id to [YOUR_ID].
6. Keep long_user_access_token mapped to {{ $json.body.access_token }}.
7. Connect Assign Auth Variables to Fetch Long User Token.

Step 3: Set Up Token Retrieval Requests

These HTTP requests exchange the user token for a long-lived token and then fetch the page list.

1. Open Fetch Long User Token and set URL to https://graph.facebook.com/v23.0/oauth/access_token.
2. Enable Send Query and configure query parameters:
3. grant_type = fb_exchange_token
4. client_id = {{ $json[' client_id'] }}
5. client_secret = {{ $json[' client_secret'] }}
6. fb_exchange_token = {{ $json.user_access_token }}
7. Open Retrieve Page Catalog and set URL to https://graph.facebook.com/v23.0/me/accounts.
8. Set the query parameter access_token to {{ $json.body.access_token }}.
9. Confirm the flow Fetch Long User Token → Retrieve Page Catalog.

Step 4: Request and Map Page Tokens

This section requests page tokens, splits the list, and maps the values for storage.

1. Open Request Page Token and set URL to =https://graph.facebook.com/v23.0/{{ $('Assign Auth Variables').item.json.app_scoped_user_id }}/accounts.
2. Set Method to =GET and enable Send Query.
3. Set query parameter access_token to {{ $('Fetch Long User Token').item.json.body.access_token }}.
4. Connect Retrieve Page Catalog → Request Page Token → Expand Records.
5. In Expand Records, set Field to Split Out to body.data and Include to allOtherFields.
6. Open Map Token Fields and map:
7. access_token = {{ $json['body.data'].access_token }}
8. name = {{ $json['body.data'].name }}
9. id = {{ $json['body.data'].id }}

Step 5: Configure the Output Table Upsert

Store the refreshed tokens in your data table with an upsert operation.

1. Open Upsert Table Records and set Operation to upsert with Match Type set to allConditions.
2. Select your target data table in Data Table ID (replace [YOUR_ID]).
3. Map columns:
4. token = {{ $json.access_token }}
5. id_page = {{ $json.id }}
6. name_page = {{ $json.name }}
7. Set the filter condition id_page to {{ $json.id }} to ensure upsert matching.
8. Confirm the flow Map Token Fields → Upsert Table Records.

Step 6: Test & Activate Your Workflow

Validate the end-to-end flow before enabling scheduled runs.

1. Click Execute Workflow to run it manually.
2. Verify Fetch Long User Token returns a body.access_token and Request Page Token returns a list in body.data.
3. Confirm Upsert Table Records writes or updates rows in your data table with token, id_page, and name_page.
4. Once successful, switch the workflow to Active to enable scheduled execution.