Looking for advise/assistance in completing an efficient Integration from AT > GS.
Let me start by saying that I know very little about scripting. I have seen some posts about getting AT data into GS, along with some pre-written scripts to do so. Thank you to those who have done so! I have additional steps that ZAP from GS to other GS after the data transfer, so using one of them that I found was over triggering my “future” ZAPs.
My Current Setup:
*New Record in AT = ZAP new Row to GS.
*Multiple views in AT (new to view = Zap specific fields to GS). these are status update views (one for each status) that only pull certain Fields into GS from the ZAP. ie: status change, date, new/old kiosk serial#, contractor.
*using ZAP (row=updated - seeing all columns) to then push data from MY GS to customers GS (which *changes weekly ) - so simply copy the ZAP and change the parameters to match their new sheet every Friday.
What I WANT:
*scripting!!! when the AT record is updated (only looking at few selected Fields) then the data is push/pull to MY GS.
*one step further; I am looking for a more efficient way to script from MY GS to customer GS = is it possible for a script to SEARCH multiple GS’s at once???
Any insight/advise/guidance/“work done for me” is greatly appreciated!
don’t know if we are allowed to seek out professional help in these Threads, but I do need help building scripts/integrations
Thanks in advance!