Editing
Google Sheets integration
(section)
Jump to navigation
Jump to search
Warning:
You are not logged in. Your IP address will be publicly visible if you make any edits. If you
log in
or
create an account
, your edits will be attributed to your username, along with other benefits.
Anti-spam check. Do
not
fill this in!
== Configuration Options and Settings == When configuring the Google Sheets integration, you should be aware of the following settings and guidelines: - **Inbound Sync Options**: - '''Import data and auto-import new data in the future''' - '''Import data and not auto-import new data''' - **Field Mapping**: - Ensure all custom fields are created in ActiveCampaign prior to mapping. - Each Google Sheet must have a header row; the first row is used for mapping. - Supported date formats: YYYY-MM-DD, YYYY/MM/DD, or MM/DD/YYYY. - For multi-select fields, use a double pipe as a delimiter (e.g., ||Option 1||Option 2||). - Currency fields should be formatted as text or number. - **Outbound Sync Settings**: - Use one Google spreadsheet per '''Add a Row in Google Sheets''' action. - Only contact fields can be synced, including standard and custom contact fields.
Summary:
Please note that all contributions to Activepedia may be edited, altered, or removed by other contributors. If you do not want your writing to be edited mercilessly, then do not submit it here.
You are also promising us that you wrote this yourself, or copied it from a public domain or similar free resource (see
Activepedia:Copyrights
for details).
Do not submit copyrighted work without permission!
Cancel
Editing help
(opens in new window)
Navigation menu
Personal tools
Not logged in
Talk
Contributions
Create account
Log in
Namespaces
Page
Discussion
English
Views
Read
Edit
Edit source
View history
More
Search
Navigation
Main page
Recent changes
Random page
Help about MediaWiki
Tools
What links here
Related changes
Special pages
Page information