Keep your community records tidy in one place. Member data lives in Google Sheets, and member profiles and activities are kept up to date in Orbit. Great for marketing and community teams that track contributors by GitHub username.

The flow reads a Members sheet and upserts each person into Orbit using their GitHub username. It then looks up all related activity rows for that person from an Activities sheet. All Orbit members are fetched, and results are merged by key, matching GitHub Username in Sheets to attributes.slug in Orbit. Each matched row becomes an Orbit activity with a title, link, and description. The setup also maps name, location, T Shirt size, and tags so profiles stay complete.

You will need a Google Sheets file with two tabs and an Orbit workspace. Connect Google Sheets with OAuth2 and Orbit with an API key. Update the workspace ID and confirm column names match the node fields. Expect faster updates, fewer copy paste errors, and clear visibility into member work such as blog posts, pull requests, or event talk links.

• Upserts Orbit members using GitHub username so duplicates are avoided.
• Reads member rows from a Google Sheets Members tab and maps name, location, size, and tags.
• Looks up all activity rows per member from a Google Sheets Activities tab.
• Fetches all Orbit members and merges data by key using GitHub Username and attributes.slug.
• Creates Orbit activities with title, link, and description for the correct member ID.
• Uses OAuth2 for Google Sheets and an API key for Orbit in n8n credentials.

• Reduce manual activity logging from 3 hours to 20 minutes per week
• Automate 90% of member updates and activity posts
• Improve profile accuracy by 80% by matching GitHub usernames
• Connect Google Sheets and Orbit without copy paste
• Handle 10 times more member updates with the same team size

1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
2. You'll need accounts with Google Sheets and Orbit. See the Tools Required section above for links to create accounts with these services.
3. Prepare your Google Sheets file with two tabs: Members with columns Name, GitHub, T Shirt Size, Location, Tags and Activities with columns GitHub Username, Title, Activity Link, Description.
4. Open the Get Members node and confirm the Sheet ID points to your file and range is Members!A:F. If needed, paste your Sheet ID. Save the node.
5. Double click the Get Members node and in the Credential to connect with dropdown click Create new credential for Google Sheets and follow the on screen instructions to grant OAuth2 access.
6. Open the Get Activities node and confirm the lookup column equals GitHub Username and the Sheet ID references the same file. Keep Return all matches enabled.
7. Double click the Add Members, Get all members, and Add Activities Orbit nodes. In the Credential to connect with dropdown click Create new credential, then follow the on screen instructions. In Orbit, create an API token and paste it when asked.
8. Update workspace ID 543 in all Orbit nodes to your actual workspace ID from your Orbit dashboard.
9. Check field mappings: Add Members should map name, location, T Shirt size, and tags from the Members tab. Identity source should be GitHub by username.
10. Run a test with one member: Execute Get Members > Add Members. Verify the profile appears in Orbit. Then run through Get Activities > Merge > Add Activities. Confirm activities show under that member.
11. If no activities post, confirm that the GitHub Username in Sheets exactly matches the Orbit attributes.slug. Fix casing or spaces and try again.
12. If Merge outputs empty items, ensure both sides share the same key values and that Get all members returns results for your workspace.
13. Optional: Add a Schedule Trigger in n8n to run daily so Sheets changes sync to Orbit without manual runs.