Answers.Body: <p>You might want to check out this recording of a CiviCon session? <a href="https://www.youtube.com/watch?v=6K3awPdA7h0" rel="nofollow noreferrer">https://www.youtube.com/watch?v=6K3awPdA7h0</a>. Not sure if it will answer all your questions but I am sure it will give you a good idea :-)</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-03-07T18:00:22.677Z
Answers.Text: Link to blog post: https://mashe.hawksey.info/2015/06/custom-regular-reporting-from-civicrm-with-google-sheets-and-google-apps-script/
Answers.UserDisplayName: Aivars
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-03-04T10:18:03.070Z
Answers.LastActivityDate: 2017-03-04T10:18:03.070Z
Answers.UserDisplayName: ErikH - CiviCooP
Body: <p>Is there an easy (semi-)automatic way to get data from CiviCRM to Google Spreadsheets?</p>
  
  <p>Data on CiviCRM side could come from search results (smart group) or a report.</p>
  
  <p>On Google Spreadsheets side I would like to import data in specific document and replace particular sheet. Other sheets would then contain formulas to retrieve and process data from the imported sheet.</p>
  
  <p>I would like the whole process to run it with a single click or even time-based (cron) to save time and eliminate human error in the process of exporting and re-importing regularly.</p>
  
  <p>Has anyone seen or made anything similar?</p>
  
Tags: <export><google>
Title: Getting data automatically from CiviCRM to Google Spreadsheets?
ThreadText: # Getting data automatically from CiviCRM to Google Spreadsheets?
  
  (Asked by: username_0 on 2017-03-04)
  
  Is there an easy (semi-)automatic way to get data from CiviCRM to Google Spreadsheets?
  
  Data on CiviCRM side could come from search results (smart group) or a report.
  
  On Google Spreadsheets side I would like to import data in specific document and replace particular sheet. Other sheets would then contain formulas to retrieve and process data from the imported sheet.
  
  I would like the whole process to run it with a single click or even time-based (cron) to save time and eliminate human error in the process of exporting and re-importing regularly.
  
  Has anyone seen or made anything similar?
  
  **Tags:** export, google
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2017-03-04. Score: 3 | Accepted answer
  
  You might want to check out this recording of a CiviCon session? <https://www.youtube.com/watch?v=6K3awPdA7h0>. Not sure if it will answer all your questions but I am sure it will give you a good idea :-)
  
  > **Comments:**
  > **username_0**: Link to blog post: https://mashe.hawksey.info/2015/06/custom-regular-reporting-from-civicrm-with-google-sheets-and-google-apps-script/  
  
  ---
  
  