Is there a way to keep two sheets synchronized?

by

One way you could accomplish this is by adding a script to both spreadsheets that copies it’s contents to the other spreadsheet on a change trigger. For example if you were to add something like the below to both spreadsheets, swapping the source and destination information around. 

var sourceSpreadsheetID = "ID HERE";
var sourceWorksheetName = "SHEET NAME HERE";
var destinationSpreadsheetID = "ID HERE";
var destinationWorksheetName = "SHEET NAME HERE";

function importData() {
  var thisSpreadsheet = SpreadsheetApp.openById(sourceSpreadsheetID);
  var thisWorksheet = thisSpreadsheet.getSheetByName(sourceWorksheetName);
  var thisData = thisWorksheet.getDataRange();
  var toSpreadsheet = SpreadsheetApp.openById(destinationSpreadsheetID);
  var toWorksheet = toSpreadsheet.getSheetByName(destinationWorksheetName);
  var toRange = toWorksheet.getRange(1, 1, thisData.getNumRows(), thisData.getNumColumns())
  toRange.setValues(thisData.getValues()); 
}

Just add a change trigger for the importData function and then when any changes are made to either document it will copy the contents to the other spreadsheet, thus keeping the both synced.

Obviously if both spreadsheets are being updated at the same time you will run into trouble.

More Related Contents:

  1. Is it possible to ‘prefill’ a google form using data from a google spreadsheet?
  2. How to protect the Apps Script code in a Google spreadsheet?
  3. Automatic timestamp when a cell is filled out
  4. Apps Script: how to get hyperlink from a cell where there is no formula
  5. How to auto select range from a filter without having to manually enter it?
  6. Script to Change Row Color when a cell changes text
  7. You do not have permission to call openById
  8. Google Apps Script, copy one spreadsheet to another spreadsheet with formatting
  9. How to get onFormSubmit to trigger automatically?
  10. Copying a spreadsheet copies all linked files as well
  11. copy data from one sheet to another in google app script and append a row, one small issue
  12. Using built-in spreadsheet functions in a script
  13. Google App Scripts cannot be given Authorization or Permission
  14. How to get the correct range to set the value to a cell?
  15. Refresh data retrieved by a custom function in Google Sheet
  16. How to extract the link from a cell now that links are not reflected as HYPERLINK?
  17. Dynamically creating spreadsheet menu items
  18. Increment Cell value by one by clicking
  19. email notification if cell is changed
  20. Dynamic selection options in Google Apps Script for forms
  21. Determine current user in Apps Script
  22. How to ignore empty cell values for getRange().getValues()
  23. Use script in all spreadsheets
  24. Iterate over range, append string to each
  25. Can the google spreadsheet ‘query’ function be used in google apps script?
  26. How to pause App Scripts until spreadsheet finishes calculation
  27. Custom Functions and Recalculation
  28. How to create INDIRECT array string of multiple sheet references in Google Sheets?
  29. Can the google spreadsheet ‘query’ function be used in google apps script?
  30. google script openById : You do not have permission to perform that action

Leave a Comment