Skip to main content
Docs
Feature Requests Onboarding Trust Center Status Page

Community

Connector Improvement: Ability to trigger Google Sheets historical re-sync through the API

Answered
Andrew Vaccaro User

Hi, we have a variety of Google Sheets that heavily use formulas, which don't seem to get picked up as "changes" to rows in a normal sync. I've tried forcing resyncs using the API, but that still doesn't pick up the changes. A historical full resync _does_ work, but the API responses seem to indicate that you cannot trigger a historical resync using the API, just the web UI. Would this be possible to add?

 

Thanks,

Andrew

Please sign in to leave a comment.

Comments

2 comments

Date Votes
  • Official comment
    Jimmy Fivetranner

    Hey Andrew, thank you for reaching out and describing things so clearly. It sounds like we have two improvements to make here:

    • Pick up changes in Google Sheets formulas
    • Allow historical resync via the API

    It sounds like either one of these would solve your issue, but we should probably fix both. Does that sound right to you?

     

  • Jimmy Fivetranner
    • Edited

    Hey Andrew, I wanted to follow-up on this ticket. If you're still experiencing the issue with formula's not being picked up as changes, this is a bug and we'd love it if you could submit a bug report we'll get on it. 

    For the other request regarding triggering historic resyncs via the API, I've added this to our backlog for consideration. Thank you for writing in!