0

Has anyone found a way to daily send results from a Searchkit result or table to Google Sheets or O365 spreadsheet? Is there a way to have Microsoft PowerAutomate or Zapier get the table? Is there a way to set it up to daily auto-send an email with the table attached? Seems that there are lots of possibilities to accomplish this.

2
  • An Export to Google Sheets extension would certainly be doable but I don't think it exists yet Jan 30, 2023 at 16:26
  • Yes the automation possibilities from SearchKit seem pretty amazing. We are not there yet, but the day is coming.
    – Iowa Boy
    Feb 1, 2023 at 5:28

1 Answer 1

0

SearchKit shows you the API query it makes. You can take the query and use it in Google Apps Script in a Google Sheet with very little code. You can also set up an email with daily results directly in Google Apps Script.

1
  • I did get this to work. The end result does not really use SearchKit in any form since I just wrote a SQL query for the Google App Script. Thanks
    – Iowa Boy
    Feb 1, 2023 at 5:27

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.