
In Progress
Posted
I have two Google sheets They need to be connected where once person updates are person A hits and it goes to person B spreadsheet to work on the next steps
Project ID: 40604377
54 proposals
Remote project
Active 6 days ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs

Hi, I have 7 years of experience in Excel automation.I can work on it as per steps you need. Let’s connect
$5 USD in 40 days
6.0
6.0
54 freelancers are bidding on average $9 USD/hour for this job

Hello! I'm an automation specialist with over 9 years of experience connecting Google Sheets, building workflows, and setting up real-time data syncing between spreadsheets. Here's how I can help: - Set up a connection between your two Google Sheets so when Person A updates their sheet, the data automatically flows to Person B's sheet for the next steps - Use Google Apps Script or built-in functions (IMPORTRANGE, QUERY, or triggers) to sync data in real time or on a schedule - Ensure the workflow is reliable, with clear rules for what gets transferred and when - Provide a simple guide so you can manage or adjust the setup later I can also add notifications or logging to track updates. Could you share the two Google Sheets (or a sample) and explain what data needs to move from Person A to Person B? I'll also need to know if you want real-time sync, scheduled updates, or manual triggers.
$5 USD in 40 days
7.3
7.3

AVAILABLE TO START IMMEDIATELY..,,. I will implement an automated solution using Google Apps Script to synchronize data instantly from Sheet A to Sheet B for seamless workflow handoff. 10+ years Advanced Excel experience, Certified VBA Programmer, MBA.
$2 USD in 1 day
6.6
6.6

Hi, I am an automation developer with 8 years of rich experience in software development. I am familiar with Google Sheets, Excel, Automation, Data Modeling, Google Apps Script, and workflow automation. I can connect your two Google Sheets so that when Person A completes or updates their work, the relevant data is automatically transferred to Person B's spreadsheet for the next step. I'll ensure the workflow is reliable, easy to maintain, and updates only the required records without manual intervention. I'm an individual freelancer and can work on any time zone you want. Please contact me with the best time for you to have a quick chat. Looking forward to discussing more details. Thanks. Emile.
$15 USD in 40 days
5.5
5.5

Hello there, I can connect both Google Sheets so Person A can send updated records directly to Person B’s spreadsheet with a single click. I will use Google Apps Script to transfer the correct data, prevent duplicates, and trigger the next workflow stage securely. The solution will be fully tested, easy to use, and include brief instructions for managing the process.
$5 USD in 40 days
5.6
5.6

Hi, There I can two Google sheets They need to be connected where once person updates are person A hits and it goes to person B spreadsheet to work on the next steps Thanks Anowar
$5 USD in 40 days
5.5
5.5

Hello, I can connect your two Google Sheets so that when Person A updates a row or changes its status, it automatically appears in Person B's spreadsheet for the next step—without any manual copying. I'll use Google Apps Script to keep the data synced in real time and ensure updates remain accurate. Regards, Muhammad
$5 USD in 40 days
5.7
5.7

Hi! I can do that. I can connect the two Google Sheets so the workflow is automatic: Person A updates their sheet and clicks a button (or changes a status). The data is automatically copied to Person B's Google Sheet. Person B can then work on the next step without manually copying anything. The system can also prevent duplicate entries and update the status as work progresses. I'll use Google Apps Script, so everything works inside Google Sheets without extra software. The setup will be simple, fast, and easy to use. Once it's finished, I'll test the complete workflow and make sure the data moves correctly between both spreadsheets.
$8 USD in 40 days
5.1
5.1

Hi, I can help connect your two Google Sheets so that when Person A updates or completes a task in the first spreadsheet, the relevant data is automatically sent to Person B's spreadsheet for the next step in the workflow. I have experience with Google Sheets automation, data processing, and workflow solutions, and I can ensure the process is accurate, reliable, and easy to maintain. I'm ready to start right away and would be happy to discuss the exact workflow and requirements. Thank you!
$5 USD in 40 days
5.2
5.2

Hello, I’d be happy to connect your two Google Sheets and automate the workflow. I hold an MBA and have extensive experience in Google Sheets, Apps Script, Excel automation, and workflow automation. I can create a seamless process where, as soon as Person A updates a row or changes its status, the relevant information is automatically transferred to Person B’s spreadsheet for the next stage—no manual copying required. The solution will: * Automatically sync data between both Google Sheets. * Update only the required records. * Preserve formatting and prevent duplicate entries. * Be easy to maintain and expand as your workflow grows. I’ve built similar spreadsheet automation solutions that eliminate repetitive tasks and improve team efficiency. I’m ready to start immediately. Best regards.
$10 USD in 70 days
4.9
4.9

Hello, After reviewing your project requirements, I fully understand that you need an automated workflow connecting two Google Sheets so updates from one user can seamlessly move to the next person’s spreadsheet for further processing. I have experience building spreadsheet automation workflows and data integrations, and I’m available to start immediately. I bring strong expertise in automation, software development, data modeling, Excel/Google Sheets workflows, and process optimization with over 10 years of experience. The key challenge is creating a reliable data flow that keeps both sheets synchronized, avoids duplicate entries, and ensures each person receives the correct information at the right stage. I can design an automated solution using Google Apps Script or suitable integration tools with proper validation and error handling. A couple of quick questions: • Are both spreadsheets owned within the same Google Workspace account or by different users? • Should the data be copied, moved, or synced while keeping the original record in Sheet A? I would be glad to review your current sheet structure and set up a clean automation workflow that is easy to maintain. Best regards, Carlos.
$8 USD in 40 days
4.6
4.6

As an experienced software developer and automation expert, I am well-equipped to handle your Google Sheets integration with a focus on streamlining your processes. My proficiency in Excel paired with my advanced understanding of software architecture positions me as the ideal candidate to fulfill your project's requirements. For over a decade, I've honed and deepened my expertise in Software Development and Automation by proficiently utilizing tools like Excel to streamline tasks. Through the connection setup between person A and person B spreadsheets, you can rest assured that any updates made will seamlessly transfer between the sheets, allowing person B to work on the next steps without any hitches or delays. Clear communication is crucial for any collaborative endeavor, which is why I'm committed to ensuring that all parties involved have a smoothly running system. With my problem-solving skills and attention to detail, I will provide an efficient and effective solution for your project needs. So why go through the trouble of manually transferring data when my automated solution can do it effortlessly?
$8 USD in 40 days
4.5
4.5

I've built Google Sheets-to-Sheets automations before—this is right in my wheelhouse. I'll set up Apps Script triggers to watch changes in Person A's sheet, then push updates to Person B's via API calls with batch writes to prevent race conditions. The integration will use a shared key column for row matching, so deletions or edits sync cleanly. Permissions will be handled via service accounts to avoid manual OAuth prompts. Validation runs daily to flag mismatches. Thanks, Andrii.
$5 USD in 40 days
4.4
4.4

With a multitude of experience in developing advanced Excel and Google Sheets tools, I am confident in my ability to seamlessly connect your two sheets. I specialize in building macros and VBA scripts to automate data transfer and foster smooth collaboration, which is exactly what your project demands. I understand the value of real-time information updates in driving efficient processes, so you can rely on me to ensure that whenever person A makes an update, person B swiftly receives it. Thanks
$4 USD in 40 days
4.2
4.2

Hi there, I am A.R.M. MASUD, with a strong data science background. I specialize in creating customized Excel-based solutions that streamline business processes, enhance data management, and enable insightful analysis. Whether it’s developing advanced macros, automating workflows, or integrating Excel with other Microsoft applications, I deliver robust, efficient solutions tailored to your specific needs. My expertise includes AR/AP Management, Financial Statement Preparation, Expense Tracking, Budgeting and Forecasting, Cash Flow Management, and APR Calculation via the Sales Force Formula. I design and develop advanced Excel workbooks with tailored features such as formulas, macros, pivot tables, Power Query, mail merge, email via Outlook and Gmail, add-ins, customized macros, and automated repetitive tasks using Excel VBA. I also create interactive dashboards for real-time data visualization, providing fully functional and customized Excel workbooks, automated workflows, and macros for efficient task management and data integration between Excel and other business systems. https://www.freelancer.com.bd/projects/excel/Advanced-Data-Processing-Chart/reviews Thank you for considering your Microsoft Excel development project. I am confident that my expertise and commitment to excellence will add significant value to your business operations. Thanks A.R.M MASUD
$5 USD in 40 days
4.5
4.5

Hi, I can set up your two Google Sheets so one update in Person A’s sheet automatically flows to Person B’s spreadsheet for the next step. That sounds like a simple handoff, but it needs to be reliable so rows don’t get missed or duplicated. I’ve built similar Google Sheets automations using Apps Script and formulas where data is synced, moved, or copied between sheets based on status changes. I’d keep the setup clean and easy to maintain, with clear triggers so the process works as soon as Person A updates a row. My approach would be to map the exact fields, define the handoff rule, and build the connection so Person B always gets the right information at the right time. I can also add basic checks to reduce errors. If you’d like, I can help set it up quickly. Best regards, Gabriel
$25 USD in 27 days
4.1
4.1

Hi, I can connect your two Google Sheets using formulas or Google Apps Script, ensuring updates from Person A automatically appear in Person B’s sheet for the next workflow step. Ready to start immediately. DM me thanks
$4 USD in 40 days
3.1
3.1

Hello, "GOOGLE SHEETS SYNC" — you need updates from one sheet to appear automatically in the other. I'll use a Google Apps Script trigger that copies rows on edit, keeping the two sheets in near‑real‑time sync without any external server. I delivered a similar verified‑leads list: https://www.freelancer.com/projects/data-collection/Polish-Dental-Clinics-Business-Leads/reviews If the sheets have different column orders, I'll map the fields so data stays aligned and avoid overwriting. Do the two sheets have the same column structure, or should I map fields between them? Looking forward to working with you. Artur Giżycki
$20 USD in 40 days
3.0
3.0

Analyze both Google Sheets, their structures, columns, and the workflow between Person A and Person B. Define the trigger event (new row, status update, or edited cell) that starts the automation. Build an automated connection using Google Apps Script or a suitable automation platform. 3.1 Handle challenges such as duplicate entries, simultaneous edits, permission issues, and data validation by implementing unique IDs, locking, and error handling. 3.2 Create a maintainable solution with clear documentation and, if required, provide sample code or a GitHub repository demonstrating similar automation techniques. Test real-time synchronization to ensure updates appear correctly in Person B's sheet with accurate mapping. Add logging, notifications, and recovery mechanisms so failed updates can be detected and retried without data loss. Deliver a scalable solution that is easy to maintain, explain the workflow, and provide support for adjustments after deployment. I believe a dependable automation should save time, eliminate manual work, and ensure every update reaches the right person accurately.
$50 USD in 40 days
2.7
2.7

Connecting two Google Sheets so updates flow automatically from Person A to Person B is a simple but easy-to-break setup if done wrong. I'll use an Apps Script trigger that fires on edit, pushing only the relevant row data to Person B's sheet in real time, no manual copy-paste needed. One thing worth knowing: Google's simple onEdit trigger can't access sheets owned by different accounts without proper permissions. If Person A and B use separate Google accounts, I'll set up an installable trigger instead, which handles cross-account access cleanly. 1) Are both sheets under the same Google account, or separate ones? Happy to talk details in chat. Shayan
$5 USD in 40 days
2.6
2.6

Hello, I can help connect your two Google Sheets so the workflow happens automatically. When Person A updates or completes a row, the relevant information will be transferred to Person B’s spreadsheet, allowing them to begin the next step without manual copying. I have experience working with Google Sheets, formulas, Google Apps Script, automation, and workflow optimization. Depending on your requirements, I can create a real-time or trigger-based solution that keeps both spreadsheets synchronized while preserving your existing data and formatting. I’ll also test the automation thoroughly to ensure it works reliably and provide a brief explanation so you can easily manage or modify it in the future if needed. I’m available to start immediately and can deliver a fast turnaround once you share the two spreadsheets and explain the workflow. Thank you, and I look forward to working with you.
$2 USD in 40 days
2.6
2.6

Tamarindo Santa Cruz, Costa Rica
Payment method verified
Member since May 30, 2015
$2-8 USD / hour
$2-8 USD / hour
$10-30 USD
$2-8 USD / hour
$2-8 USD / hour
₹750-1250 INR / hour
$2-8 USD / hour
₹750-1250 INR / hour
₹1500-12500 INR
$250-750 USD
₹1500-12500 INR
£250-750 GBP
₹1500-12500 INR
₹600-1500 INR
$7-11 USD / hour
$250-750 USD
$8-15 USD / hour
$250-750 USD
$30-250 USD
$10-30 USD
₹600-1500 INR
$750-1500 USD
$250-750 USD
₹600-1500 INR
₹750-1250 INR / hour