title: Auto Copy Row imports too fast?
body: <p>I'm using Google Sheets. Here's the scenario:</p>
  
  <p><strong>WB #1</strong>: Raw Data created from Form Data entered by customer. To be left alone.</p>
  
  <p><strong>WB #2, Sheet A</strong>: Importrange codes to bring in data from WB #1 and a few fields added to change some info to abbreviations.</p>
  
  <p><strong>WB #2, Sheet B</strong>: Daily Workable, which currently will bring in each row from Sheet A if a "Y" is typed into the first column.</p>
  
  <p>I am hoping automate this so when Sheet A is filled automatically from WB #1, it automatically sends a copy to Sheet B without having to type a "Y" as a trigger.</p>
  
  <p>I thought I could set it to another field like an Email field, so that when the row automatically comes in from WB #1, it fills it with a email address which will always contain a "@". So I set the code to do that, but the rows are filled in so quickly that it doesn't move them to Sheet B.</p>
  
  <p>When we were testing last night and still using the script that had a row move when a "Y" was placed in the first column, if you typed the "Y" in too quickly to each row, it wouldn't move that row over to Sheet B. If you do that exact same thing slowly, it moves them all over correctly. So it seems that auto copy is working too fast. </p>
  
  <p>How can I do that?</p>