Data synchronization from Google Sheets to Orbit

• Sync member data from Google Sheets to Orbit for streamlined management.
• Automatically update member information based on changes in Google Sheets.
• Add activities related to members in Orbit based on data from Google Sheets.

Retrieve member data from Google Sheets using the Google Sheets integration. Fetch existing members from Orbit to compare and merge data. Merge member data based on GitHub usernames to ensure accuracy. Upsert members into Orbit, adding new entries or updating existing ones. Lookup activities associated with members and add them to Orbit.

1. 1
   Import the workflow template into n8n.
2. 2
   Connect your Google Sheets and Orbit accounts using OAuth2 credentials.
3. 3
   Configure the Google Sheets node to point to the correct sheet and range.
4. 4
   Set the workspace ID in the Orbit nodes to match your Orbit account.
5. 5
   Test the workflow to ensure data is syncing correctly.