I am wanting to create a weekly report (via Zapier)
We are migrating from "To-do" lists to "Card Table" and need a weekly report demonstrating “all the activity for that week, and upcoming week - project specific.
The next steps for Zapier is to attain the "Basecamp Personal Access Token". I’ve spoken to Basecamp and they said this would need to be requested via Zapier.
*current triggers are everything but card tables.
Question
How to obtain a Basecamp API token for connecting Card Table in Zapier
+6- Zapier Solution Partner
Hey
Card Tables are not supported natively right now through Zapier as of right now. You can see all the triggers/ actions for basecamp here- https://zapier.com/apps/basecamp/integrations
But there is a workaround is through Baecamp 4 API (bc3-api) and poll for changes. See more about Basecamp API documentation here- https://github.com/basecamp/bc3-api
You will will probably have to call multiple endpoints
-
Call GET /buckets/{project_id}/card_tables/{card_table_id}/columns.json → get all column IDs for that card table.
-
For each column, GET /buckets/{project_id}/card_tables/{card_table_id}/columns/{column_id}/cards.json → pull the cards.
After that you can store it in Google Sheets/ Zapier tables and send a weekly report from there. I know it can get a bit more complex and technical but if it’s important for you, you can give this approach a try. Hope it helps!
PS: If you need more active help, I’m happy to connect through my Zapier Solution Partner page if you’d like to reach out here- https://zapier.com/partnerdirectory/automation-jinn
+11- Community Manager
Hi there
As Sparsh mentioned, Card Tables aren’t supported at the moment, but we do have a feature request open for adding support. So I’ve gone ahead and added your vote to that request. While I can’t guarantee if or when this will be implemented, we’ll be sure to email you if it becomes available.
Hopefully the workaround Sparsh suggested will help in the meantime. Let us know if there’s anything else we can help with!
Hi
Totally feeling your struggle here — the move from To-dos to Card Table is great, but the missing triggers definitely slow things down. For weekly reporting, Zapier really does need that Basecamp Personal Access Token, and it’s confusing when Basecamp redirects you back to Zapier without a clear path. I’d push Zapier support again and insist they generate the token or confirm when Card Table endpoints will be supported. Since everything else works except Card Tables, it really comes down to Zapier enabling that access, so keep referencing your workflow and the URL you’re connecting from to help them trace it quicker.
With Best Wishes!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.