Answers.Body: <p>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.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2023-02-01T05:27:06.277Z
Answers.Text: 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
Answers.UserDisplayName: Iowa Boy
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2023-01-28T06:31:48.567Z
Answers.LastActivityDate: 2023-01-28T06:31:48.567Z
Answers.UserDisplayName: Lars SG
Body: <p>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.</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2023-01-30T16:26:16.443Z
Comments.Text: An Export to Google Sheets extension would certainly be doable but I don't think it exists yet
Comments.UserDisplayName: Andrew West
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2023-02-01T05:28:38.980Z
Comments.Text: Yes the automation possibilities from SearchKit seem pretty amazing. We are not there yet, but the day is coming.
Comments.UserDisplayName: Iowa Boy
Tags: <searchkit><automation>
Title: Automate from Searchkit to Google Sheets or Office 365
ThreadText: # Automate from Searchkit to Google Sheets or Office 365
  
  (Asked by: username_0 on 2023-01-28)
  
  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.
  
  **Tags:** searchkit, automation
  
  > **Comments:**
  > **username_1**: An Export to Google Sheets extension would certainly be doable but I don't think it exists yet  
  > **username_0**: Yes the automation possibilities from SearchKit seem pretty amazing. We are not there yet, but the day is coming.  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_2 on 2023-01-28. Score: 0 | Accepted answer
  
  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.
  
  > **Comments:**
  > **username_0**: 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  
  
  ---
  
  