Google Sheets to Orbit: Community Contributions
detail.loadingPreview
Automate adding community contributions from Google Sheets to Orbit.
🚀Ready to Deploy This Workflow?
About This Workflow
Overview
This workflow automates the process of transferring community contributions, such as member details and their activities, from Google Sheets into your Orbit workspace. It's designed for community managers and project maintainers to keep their Orbit data up-to-date with minimal manual effort.
Key Features
- Reads member data (GitHub username, name, t-shirt size, location, tags) from a Google Sheet.
- Reads activity data (title, link, description) from another Google Sheet based on GitHub username.
- Upserts members into Orbit, creating new members or updating existing ones.
- Adds activities to the corresponding members in Orbit.
- Merges data to ensure accurate activity descriptions are associated with the correct members.
How To Use
- Import the workflow: Add this workflow to your n8n instance.
- Configure Google Sheets Credentials: Connect to your Google account via OAuth2.
- Configure Orbit Credentials: Connect to your Orbit workspace using your API key.
- Update Sheet IDs and Ranges: In the
Get MembersandGet Activitiesnodes, replace placeholdersheetIdvalues with your actual Google Sheet IDs and ensure the specifiedrangeandlookupColumnare correct. - Update Orbit Workspace ID: In the Orbit nodes, ensure
workspaceIdis set to your Orbit workspace ID. - Map Data: Verify that the field mappings in the
Add MembersandAdd Activitiesnodes correctly correspond to your Google Sheet columns. - Activate the workflow: Trigger the workflow manually or set up a recurring schedule.
Apps Used
Workflow JSON
{
"id": "97bd6925-4e28-4692-8aec-076b418b06f9",
"name": "Google Sheets to Orbit: Community Contributions",
"nodes": 0,
"category": "Googlesheets",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: 97bd6925-4e28...
About the Author
Crypto_Watcher
Web3 Developer
Automated trading bots and blockchain monitoring workflows.
Statistics
Verification Info
Related Workflows
Discover more workflows you might like
Parse Inbound Orders and Store in Google Sheets
Automatically parse inbound order emails, extract details, and store them in a Google Sheet.
Typeform to Google Sheets with Conditional Notifications
This workflow triggers from Typeform submissions, appends data to Google Sheets, and sends notifications based on a severity threshold.
Community Contributed Google Sheets Template
This template helps generate metadata for community-contributed Google Sheets templates.
Community Contributed Google Sheets (Unverified)
Retrieves data from a Google Sheet for community-contributed content that requires verification.
Community Contributed Google Sheet Template (Unverified)
This template allows users to contribute data to a Google Sheet, which is then appended by n8n.
Community Contributed Google Sheets Template (Unverified)
Automates the process of organizing attachments from emails into Google Drive folders based on date and company. This template is community-contributed and currently unverified.