Can I Sync Data From Multiple Worksheets to the Same Table Using Merge Mode?

Question

If I set up my connector using the Merge Mode sync strategy, can I sync data from multiple worksheets to the same table in my destination?

Environment

Connector: Google Drive Sync Strategy: Merge Mode

Answer

While setting up your connector using the Merge Mode sync strategy, you can only include one worksheet from a Google Sheets file. Therefore, it's not possible to sync multiple Google Sheets worksheets to the same table. To sync multiple worksheets, you must create a separate connector for each.